>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
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.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I've run into the same, Greg. It is quicker in nearly every case I have benchmarked. I can't say that I have ever seen differences as extreme as the ones you mention, though.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell