>On a freash reboot of both server and workstation we can get a 0.4 second response time when doing a query. This response time continues until a second workstaion open the database, then both workstaions begin to get a 6.0 second response time, which continues until the next boot. Response time at the server console is always less then 0.5 seconds. Several workstations have been tried. Range is 486DX66 w/16M up to 200MHzPentium w/80M. Difference is less then 1 second.

Nicole,
Is the query optimized?? I mean the following... Are there indexes that match the query conditions?? Is VFP building a cursor or is it just reopening the table in question again in another workarea??

Please, more details are needed to help...

Thanx!

Tony Miller
Vancouver, Wa