Scott,

In addition to what others have suggested, what OS is used for the network.

If you are using Win9x or Win2K Pro AND you are holding LOTS of records until TableRevert/TableUpdate, there can be problems there too.

good luck


>Hello All -
>
>I have a multi-user VFP6 SP5 EXE installed at a client site where the data (DBFs) and the application all reside in a common directory on a server. Each user has a shortcut to the executable on their desktop. During a data-importing process, I enable optimistic table buffering on 4 tables and update the tables with new data. Updates are made to approximately 20-30K records. I then calculate before/after counts and totals for display and allow the user to cancel (TABLEREVERTs) or proceed (TABLEUPDATEs).
>
>When only one user is logged in to the system, the TABLEUPDATEs on the 4 tables occur in about 2-3 minutes. However, when there is more than one user logged in to the system, the performance degrades to about 2 HOURS!
>
>Can anyone offer an explanation as to why the performance with more than one user logged in is so slow? Do you have any suggestions for improving the performance?
>
>Thanks,
>Scott