Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Steve,
>I am developing a multi-user system with the data and exe's on an NT4 Server. When executing a procedure which processes a file containing 6000 records from single a maching, the procedure takes about six seconds. However when two or more users execute the same procedure it takes at least three minutes.
>
>I have also tries running the procedure twice from the same machine, and it only takes about six seconds.
Besides upgrading your server, be sure that you DON'T use a index tag on DELETED() when SET DELETE = ON, This one does a great job on just slow down database access.
Walter,
Précédent
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