General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Jim,
have you thought abaout the different ways Seek() and Rushmore operate ?
Your arguments are valid for seek(), but if you have a very large table, which gets written to (into cdx-mapped fields!) and subsequently queried on those fields, rushmore reads the whole index again, since it is marked "invalid". This should be much worse if operating on a fragmented .cdx. The same argument should be checked if querying a large table NOT on cdx-based criteria - then VFP has to read the table in sequential order.
just my 2'c
thomas
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