Walter Meester
HoogkarspelNetherlands
Mike Yearwood
Toronto, Ontario, Canada
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
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