Hi Thomas and thanks.

When using the FoxPro command window for testing from the workstation, I am not setting TMPFILES. It seems with the test as described below, that can not be effecting me. Again, the test is:

X = Live
Y = Test (a copy of live)

From a workstation using foxpro command window:
Set exclusive off
open database X:\data\inmatetrustfund.dbc
select * from inmatetrustfund!bill_code_hist inner join inmatetrustfund!bill_codes on bill_code_hist.cbill_codes_id=bill_codes.cid into cursor lcresult
-- takes 101.48 seconds --
close databases all
open database Y:\data\inmatetrustfund.dbc
select * from inmatetrustfund!bill_code_hist inner join inmatetrustfund!bill_codes on bill_code_hist.cbill_codes_id=bill_codes.cid into cursor lcresult
-- takes 5.34 seconds --

We did turn OpLocks off on the server yesterday but it had no effect.

Thanks,
John