Bad hub/switch with numerous collisions? I have better results with switches. Although the EXE will run in the local memory, dragging an EXE across the network could be a (small) factor as well. Is it possible to test using a local install of the EXE with the data still on the server?
>>Bandwith is one. Locking contentions? I assume queries are optimized (Rushmore for DBF, proper indexes for SQL Server, etc.)
>
>As much as we know for now they seem to be.
>
>>Does the data server have enough power? Memory, CPU consumption?
>
>Networking guy says it does. What's a good configuration?
>
>>Heavy net traffic on other unrelated jobs?
>
>No jobs running during the day when most users are on.
>
>>The workstations have a local copy of EXE, right?
>
>No, the exe is on the server with the apps and data.
>
>>Are TEMP files being created/destroyed in local workstations?
>
>Yes.
>
>>Just some ideas.
>
>Thanks!
Mark McCasland
Midlothian, TX USA