>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.
>
>Does anyone have any ideas ?
>
>Thanks
>
>Steve
Steve,
First off, get more memory for your server. I don't say that lightly. I know that it will probably be expensive because of the age of the machine and the type of memory used but see if you can. The reason for this is to enable the server to cache more disk data so it can service disk requests faster.
Next, when you say data and EXEs are on the server, are the TEMP files created by VFP also created on the server. If you don't have a CONFIG.FPW compiled within your APP or located in the appliaction directory with a statement like TEMPFILES=C:\TEMP (or some local drive:/directory) then they are. This causes unnecessary (IMO) network traffic and server disk access.
You can alos look at the network connection itself. 100BaseT is relatively inexpensive (card and hub both for <$80 US). If you aren't already using this you could upgrade and that would increase bandwidth by an order of magnitude.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao