SNIP
Hi Bruce,
Basically I use SEEK (either one) whenever I can, but something came up last month and I'd like to get to the bottom of it. Your observations with LOCATE may help in that quest. . .
The manual says that any command (including LOACTE) will *not* be Rushmore optimized when a WHEN is included in the FOR condition(s). JimB says that WHEN has no effect on Rushmore.
So the question is: Did your observations of LOCATE include a WHEN condition?
Cheers,
Jim N
>
>Also, I've found that on large tables any SEEK is waaaaayyy faster than even a fully optimized LOCATE. For whatever reason, Rushmore is not very efficient with LOCATE...
Previous
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