Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement