SET ORDER plus SEEK vs. SEEK(a,b,c)

Author: Michael J. Babcock, MCP

Posted: 2007-09-11 at 11:24:53

I'm finding code where the developer had done a SET ORDER TO and then SEEK

command afterwards instead of using the SEEK(a,b,c) function with its

parts. I'm not sure when the SEEK(a,b,c) function came to be, so perhaps

this is because it was written prior to that?

IAC, I thought I had heard that doing a SET ORDER TO on a network table

was slow or caused a performance hit, especially since all we want to do

is use the index to check for the existence of a condition that could

nowadays be done with the SEEK(a,b,c) function. While refactoring, should

this be done (...replacing the old SET ORDER plus SEEK command with the

SEEK function instead)?

Just curious...tia!

--Michael

©2007 Michael J. Babcock, MCP