Information générale
Catégorie:
Codage, syntaxe et commandes
>Just a question I have in optimizing an application that I'm working on. What's faster a SEEK on an index or a SELECT with a WHERE statement
Hi Ed,
You can determine which is faster by timing a loop of about 100,000 iterations where your SEEK or SELECT statement is in the middle. Do you need to be on the record or just need the values? SELECT won't put you on the record but it will give you the values just as well as the SEEK. If you just want to know if the key value is there you can also use INDEXSEEK() which was created for this purpose.
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