Dear Charlie,

Thanks for your suggession, I tried to find out the time take for each process. And as I mentioned it takes a long time before showing me a the first screen for the Formset. Basically this means, my dataenvironment or loading of controls takes a long time.

How would I identify, which one is slower, and how to improve the speed.

Awaiting yr reply

Thanks again for your help.




>As you may have heard, the way to make VFP fast is to take out the slow parts. I think we should know a specific action that is slow, and under what conditions. If loading a form is slow, what is the slow part? Is it the control creation, getting the data, or something else? Does it matter if you test during the day with 30 workers on the system, or is that not significant?
>You can run the app with code like this bracketing specific sections. I usually have the Debug window in the FoxPro frame and observe its output.
>Timer = SECONDS()
>More code.
>DEBUGOUT "Section X took " + ALLTRIM(STR(SECONDS() - m.Timer,10,3))
>or use the Coverage Profiler.
>Again, find out what code is slow, and if activity by others is significant.
>
>
>>Dear UTites,
>>
>>I developed an application using VFP6, and is being used by about 30 users, in out LAN. We have following config for our network;
>>
>>SERVER : PIII500, 128MB RAM, 9.1GB HDD.
>>WORKSTATION : P133,16MB RAM, 2.1GB HDD.
>>
>>EXE size : 5MB, excluding BMP,ICO and Reports files (FR?)
>>
>>All files are stored on the server, and everybody is accessing the EXE from a shortcut created on their computer pointing to this exe file.
>>
>>The main problem is performance, sometimes the performance especially, for Loading FORMS, Running reports is extremly slow. can anybody please help me or point out what exactly could be done.
>>
>>Another weird thing I noticed is, if I use Rushmore for counting or summing or even Appending records, it takes atleast 10-15 times more time, than if I use DO while or go record by record. At present I have around 5000 records to process, but I'm worried what happens if I'll have ahuge databse to handle.
>>
>>I hope anybody can provide me some answers to these performance issues.
>>
>>Thanks in advance,