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