General information
Category:
Coding, syntax & commands
Title:
INDEXSEEK is faster than SEEK
From what I have read I was under the impression that there wouldn't be any performance increase using INDEXSEEK() over SEEK(). I have a looping counting and totaling procedure where all I did was change a SEEK() to INDEXSEEK() with the move record pointer parameter set to .T., the time the procedure took with the SEEK() was 363 seconds, after changing to INDEXSEEK() the procedure takes 8 seconds. This occurs no matter if I reboot after each run or not, so caching isn't an issue.
Next
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