Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's faster - SELECT SQL or LOCATE?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00383232
Message ID:
00383250
Views:
43
>I expect the table to grow pretty large - over 1 million records. In general...what is faster - a LOCATE or SELECT SQL statement for locating a single record?
>
>Thanks,
>Doug

Doug,

The fastest way for locating a sinle record is SEEK assuming that you have appropriate index.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform