General information
Category:
Coding, syntax & commands
>The speed improvements? I have seen speed improvements of 10X or more...
>
>So you see, the seek is a bit of a red herring here.. The real speed is in using the WHILE clause. Not the FOR clause. I bet 80% of the time a FOR clause is used, A WHILE clause with a SEEK could be used instead, dramatically improving performance...
>
I see... my mistake.. I thougt we were comparing finding a record with seek vs locate... You're right, I use the SEEK, SCAN REST WHILE all the time.
Let's not get into LOCATE vs GO TOP either... {G}
BOb
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