Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up search - Locate For or Seek?
Message
From
28/07/2000 05:18:56
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00397065
Message ID:
00398047
Views:
32
>>
FOR lnJ = 1 TO 10000
SET ORDER TO pID
SEEK(699)
SET ORDER TO
ENDFOR
>>

Hi Brien.

I wouldn't include the set orders in the above code snippet. You already set it before starting this loop. Further, this makes your test not merely compare SEEK against LOCATE.

Try adding SET COLLATE TO "MACHINE" before doing this. SP4 supposedly defaults to something else (?)

SEEK should be way faster than LOCATE.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform