>>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

Nicole,
Well, what does the sql look like?? As I asked earlier, are there index tags for each condition you are joining on or where you where clause is?? Are the tags built with a for clause of NOT Deleted() so that deleted records are being ignored?? What size tables and how many are you joining??

Thanx,

Tony Miller
Vancouver, Wa