A while back when tracking a performance issue we tracked it to delays in pulling the sql data. While that was true, turns out there is more to the story.

I created a form with no controls. In the .Load, a sql created a non-updateble cursor that contains about 25 records. The sql takes about 5-6 seconds to run. That is as expected. But then when the form.initcontrolsinet runs it takes 9 seconds to do I dont know what, it says "app", and it takes 9 seconds to save the form with a 25 record cursor.

Look at this:

The form is launched upon startup. Then when the user "opens" it, you get a 9 second save and a 10 second "app". All for a form with a 25 record cusrsor and no controls. Where to go?

Hi Tuvia I think that if you add in your cursor created by sql command, a candidate index, FoxInCloud will be more speedy for saving and restoring the whole of your cursor for each traitment of each http request..

Regards Gilles

Will try that, thanks.

That did not make a difference, I am going to have to dig deeper, something about this particular cursor is an issue, the other cursors are fine.