>Hi there! I am a reletively new FoxPro user and I had a question concerning searching a table. I am currently using Locate for's to search for my results, but I have been told that seek is quite faster. Is there something faster than seek? And can anyone explain in a nutshell what makes one faster than the other? Also, I already have a ton of indexes on the table too. Thanks for any answers you all can give me! :)


FW(little)IW

My impression has been that if an expression is Rushmore optimizable, then Fox will use the correct index to perform the search. To me this means that the LOCATE has been converted to a SEEK internally.

For a fully optimizable expression, I would think that the SEEK should be marginally faster by the amount of time needed to determine if the expression is, in actuality, optimizable.

........Rich