Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only