General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only