I'm not sure how to phrase the topic, but here's what's happening.
My client has a Win2K server and Win2K workstations, 100 Mbps network, switched at the server and a RAID (mirrored) in the server.
When I put a copy of their database on a local hard drive and query it, it takes about 10 seconds to go through 400,000+ records and return the recordset.
When I put the database on the server, it takes 5 minutes.
A colleague with a simiilar setup ran the tests--and got response times of around 10-15 seconds, so I'm sure it some kind of setup issue on either the server or the workstations, but I'm darned if I can figure it out.
We have turned off virus checking (McAfee) on the data folders and there's no compression being used on the server. No change in the timing was noted.
Op locks are turned off on the server as well.
As a related issue (and I don't know if this is a red herring or if it'll ring some bells), I used Explorer to open a folder on the server, highlighted all 640 files (totalling 330meg) in the folder and the pressed DEL. There was a significant delay until the "deleting" animation showed up.
All suggestions gratefully accepted....thanks