Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fragmentation - why it is usually good for VFP native da
Message
From
19/01/2003 07:18:07
 
 
To
15/01/2003 13:47:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00742043
Message ID:
00743246
Views:
16
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
Map
View

Click here to load this message in the networking platform