Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Ok, thanks.
Michelle
>First off, use SCAN WHILE !EOF() instead of just SCAN. You will get much better performance results (at least I did). SCAN WHILE respects the index while SCAN does not. You will get the same results because after the SCAN goes to the next record, it then has the added overhead of bouncing that record against the active index to see if it matches.
>
>Second, you can leave out one SKIP (the initial SKIP -1) because you are already running a SCAN. You have already processed the previous record so store that value and use it as you process the current record. You will still need to SKIP 1 to get the next record and SKIP back to the current record but you should be okay.
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