Hi,
I need design ideas to improve the screen display speed of Zoho Creator’s form that has lookup fields.
Some lookup destinations has over 400,000 records.
I think that the lookup fields automatically read the records of the lookup destination at the timing before the lookup fields is displayed, but is there any way to disable the reading or control the number of records to improve the display speed?
We'd tested to investigate what is the main reason to slow the screen speed as follows:
Testing (Unit: sec) |
||||||
# |
Form |
1st |
2nd |
3rd |
Average |
Our Conclusion |
1 |
Production |
5.4 |
5.5 |
5.8 |
5.5 |
|
2 |
Testing Copied from production and fields number were reduced as 50%. lookup fields remain as production. |
3.6 |
4.6 |
5.0 |
4.4 |
I think we can mprove the screen display speed, If we can do the followings: do not fetch the lookup destination before displaying the screen, after displaying the screen, we'd like to dynamically set options in the lookup fields by using Deluge script. |
3 |
Testing Copied from #2 form. Lookup fields are changed to simple select fields |
1.8 |
0.5 |
1.5 |
1.3 |
|
In order to improve the screen display speed, do not fetch the lookup destination before displaying the screen, after displaying the screen, we'd like to dynamically set options in the lookup fields by using Deluge script.
Can we do the above idea or do you guys have any idea to improve the screen display speed?