Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
No (more?) bloat with REINDEX command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00523073
Message ID:
00523335
Vues:
18
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform