Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SET KEY and LOCATE FOR
Message
De
28/09/1998 16:06:27
 
 
À
28/09/1998 15:59:48
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00141608
Message ID:
00141609
Vues:
19
Hi Nancy ----

>Is LOCATE FOR going to be relatively efficient for a situation where SET KEY limits the records to, oh, a few dozen records at most? IOW, does LOCATE FOR use the SET KEY index? I have hardly ever issued a locate, since have been scarred by them in Clipper days. :-)

I just tested this with a 60,000 record table. I set the index to lastname, did a SET KEY TO "SMITH" and then a LOCATE FOR lastname="SMITH"....it came up very fast.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform