>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?
Slowdowns in multi-user scenarios are often caused by antivirus scanners, particularly Norton AntiVirus. Try disabling real-time scanning on both server and workstations and see if that makes a difference.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up