Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Always better to ...?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00338054
Message ID:
00339091
Vues:
29
>A blind LOCATE is the same as LOCATE FOR .T.. The Filter is optimized, as is >the deleted condition if the indexes exist.

So why if we are talking about optimization does a locate nooptimize run 250% faster than a locate on a 40K record table and a 100K record table? This is done on tables without filters.

Actually I ran the same test with a filter that did not match the index expression and the findings were about the same.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform