Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>Hi All. I have been reading some threads about SCAN - ENDSCAN. Due to old habits I have used DO WHILE but am interested in the speed improvements that SCAN ENDSCAN appear to offer.
>
>Any gotchas to watch out for when converting DO WHILE loops to SCAN ENDSCAN? I did read Dragan's comment about nested SCAN's on the *same* file. Are there any others?
Don't forget to take the SKIP command out.
FWIW, last time I tested (which was with VFP 7), on an unordered table, SCAN was about 1.5 times as fast as DO WHILE. For ordered tables, it's not quite as clear-cut; the differences seem to depend on the index order.
But overall, you can't go wrong using SCAN for looping through a table.
Tamar
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