Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>>I want to scan a table from bottom to top. Currently, I am using a while loop for that. Is there any faster way like scan?
>>>>
>>>>Thank you,
>>>>Ali
>>>
>>>No, not really. Do while and SCAN are equavalent in speed, AFAIK.
>>
>>I have not tested this for a few years but SCAN was 15% faster than using a DO WHILE loop.
>
>Interesting. I forgot that SCAN respects the order set on the table...
>
>Also why would we have a speed difference in WHILE LOOP vs. SCAN? It's doing the same, though we need to write more code. I guess internally it uses something different...
SELECT table1
DO WHILE NOT EOF()
DO SOMETHING && which changes workarea without putting it back.
select table1
IF NOT EOF()
SKIP
ENDIF
ENDDO
versus
SELECT table1
SCAN
DO SOMETHING && which changes workarea without putting it back.
ENDDO
Précédent
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