Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A question about SEEK()
Message
From
17/03/2000 14:08:21
Walter Meester
HoogkarspelNetherlands
 
 
To
16/03/2000 18:42:58
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00346748
Message ID:
00347226
Views:
31
Mike,

>Don't forget the NOOPTIMZE clause. Its my belief that VFP wastes some time trying to optimize a LOCATE FOR when there are no indexes.

*Sidenote*

I would say that this would get worse if the ARE indexes and it is a view with less than about 50 a 100 records in it. The time needed to kick in rushmore is equal or more than scanning trough the table sequently.

IMO it doesn't pay to index small tables for rushmore boosting purposes only.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform