Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No (more?) bloat with REINDEX command
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523073
Message ID:
00523335
Views:
16
That is kind of what I was suspecting. I have some files with 12 million and 14 million records and the temp files seem to get cleared between each set of generating/indexing cycles. It has always been too fast to read the incrementing count on the Indexing, even with FPW 2.6.

Maybe on smaller files the indexing engine is able to make do with one pass...which might make an improvement on how the cdx file is actually stored on the disk.

>
>On the test I did, I used a table with nearly 2 million records, and 7 index tags. The table is 1.5 GIGs in size. The reindexing operation took nearly
>1.5 hours, and it did make multiple passes through the table creating the keys. the indexing then was less than 2 seconds. As each succeeding key was added, the operation took measurably longer (a few seconds) to complete. The temp files grew quite large during the key creation part of the operation, were emptied, then grew again on each pass.
>
>As a result, I am as lost as ever before <eg>
Tom

Life happens, don't blink.
Previous
Reply
Map
View

Click here to load this message in the networking platform