FoxInCloud
Response TIme
Gravatar is a globally recognized avatar based on your email address. Response TIme
  Arcadio Bianco
  All
  Dec 16, 2019 @ 04:49pm

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?

Gravatar is a globally recognized avatar based on your email address. re: Response TIme
  Gilles Lajot-Sarthou
  Arcadio Bianco
  Dec 16, 2019 @ 11:19pm

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

Gravatar is a globally recognized avatar based on your email address. re: Response TIme
  FoxInCloud Support - Thierry N.
  Arcadio Bianco
  Dec 17, 2019 @ 07:39am

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.

Gravatar is a globally recognized avatar based on your email address. re: Response TIme
  Arcadio Bianco
  FoxInCloud Support - Thierry N.
  Dec 17, 2019 @ 02:53pm

Thanks for your tips, Gilles and Thierry. I'll check what they said.

© 1996-2020