Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Slow file access
Message
De
09/08/2000 03:50:27
Walter Meester
HoogkarspelPays-Bas
 
 
À
08/08/2000 09:41:27
Steve Jones
Business Systems Services Uk Ltd
Swansea, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00402187
Message ID:
00402674
Vues:
12
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
Fil
Voir

Click here to load this message in the networking platform