Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
When does Rushmore Optimize?
Message
De
02/11/1998 13:52:04
 
 
À
02/11/1998 13:47:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00153608
Message ID:
00153647
Vues:
15
>Edward -
>
>Maybe I didn't explain myself well enough. The XX.DBF file is just a test file. When we run this query against our regular table (about 4,000 records), it takes much, much longer.
>
>And no, I don't want to run the query 4,000 times, even at 0.04 seconds each!
>
>- George [Indexing on DELETED() helped a little. But the query still took about a minute to run, however (56 seconds, I think.)]

It's strange that you get so different results, especially for 4K table. BTW, what is the best time for real case? Do you restart VFP after each query making bench tests?
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform