>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.

Use the Coverage Log! It is perfect for identifying bottlenecks, but hardly anyone ever thinks to use it. It will give run-time for all events & lines of code within, then just look at the large times to see what's slow. Note that the application will run slowly with the log on, that's normal, do not be concerned about it, it takes extra time to log in the code timings...