Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement