Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexseek
Message
De
04/09/2014 10:11:29
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
04/09/2014 09:52:15
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01607037
Message ID:
01607045
Vues:
59
>Mike,
>
>Try keymatch() instead. That is definitely faster than seek.
>
>Walter,
>
>>Hey all
>>
>>Just FYI
>>
>>I have rarely had a need to use indexseek. I read it's "fast". I thought it's faster than other things, but it's not faster than seek. The only benefit I can see in it is it does a seek without moving the record pointer. That's good for uniqueness checking during adding/editing of a record.
>>
>>On a 27 million record table, indexseek and seek are almost exactly the same speed.

It's fast alright. It moves the record pointer and puts it back, which might give me a bit of grief. I'll check. Also to get the index #, I'd have to use tagno(). That would slow the process down.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform