Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow file access
Message
From
09/08/2000 03:50:27
Walter Meester
HoogkarspelNetherlands
 
 
To
08/08/2000 09:41:27
Steve Jones
Business Systems Services Uk Ltd
Swansea, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00402187
Message ID:
00402674
Views:
11
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,
Previous
Reply
Map
View

Click here to load this message in the networking platform