Information générale
Catégorie:
Codage, syntaxe et commandes
>So what's your opinion now? Still think IN is faster/better performance?
Well, I asked you for the results. :) So, no, I'm not sure it is faster in any condition. :) Although, I would try to make the test (if possible) with all tables on local drive.
Also, extremly important: close and reopen VFP between each 2 SELECTs in order to get accurate results. VFP is optimizing from one SELECT to another when this is possible. Since the SELECTs are on the same dbfs, it's almost sure some optimizations are done as you pass from one SELECT to another.
Thanks for the results and I'd be interested to hear about any new results you may have.
Vlad
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