How can I decrease response time? Each event is taking about 2 seconds, most of the time being used on "nrestenv" (around one second) which ends up making my application a little slow. Where do I have to check to improve this?
Hi Arcadio The restoration time is extended with the size of the cursors, views, buffered tables, etc. To reduce the working time of FoxInCloud in its backups and restores of user contexts: 1 - Reduce the dimensions of cursors, views and buffered tables as much as possible 2 - Systematically have a candidate / primary index on each table, view or slider 3 - Avoid leaving a view in EOF () after loading (this is what takes the most time for FoxInCloud to process) 4 - Limit the use of grids in forms 5 - Increase the execution speed of the WEB machine.
On my applications identical to yours, the average processing time for HHTP requests is less than 0.6 seconds .. and could go lower if I avoided EOF () on my views.
Regards Gilles
Hi Arcadio,
use <path to app>\temp\<userID>\_<userID>__xxx_appenv
browse last
&& you get this table:
cScope;C;1 && 'M'enu | 'P'opup | _'S'creen | _'V'FP | 'G'lobal | 'A'ppHost
cName;V;128
cType;C;1 && Type()
mValue;M
nSaveMS;I
nRestMS;I
nSaveMS
and nRestMS
are the save and restore time in ms for each item. sum nRestMS
should be close to wwRequestLog.nRestEnv
.
For further help, please share the items that take most time to restore.