Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed of SEEK, SEEK(), LOCATE, and SQL SELECT
Message
From
29/06/1999 09:45:14
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
28/06/1999 23:46:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00235086
Message ID:
00235195
Views:
30
Hi Peter.

I'd like to see the code you've been running. Its important to compare apples to apples. For example, if you...

set order to tagname
for i = 1 to 10
seek "something"
endfor

versus...

for i = 1 to 10
set order to tagname
seek "something"
endfor

You'll get very different timings. I bring this up because...


for i = 1 to 10
set order to tagname
seek "something"
endfor

is the same behavior as...

for i = 1 to 10
=seek("something",,"tagname")
endfor

and look at the lookup function. It used to be the fastest way to seek something and return a value (like a decription for a code from a lookup table). Just remember to specify the forth parameter (index tag name).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform