Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CDX size bloating on large number of INSERTs
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00495402
Message ID:
00495427
Vues:
9
>>Nope, that's the way it works. REINDEX will simply tacks the new keys at the end of the CDX and not reuse the old space. This is called Index Bloat. You need to DELETE TAG or DELETE TAG ALL before doing and INDEX ON (At this point, REINDEX will not work). There is a KB article on my web site that explains this.
>
>Joe is saying that he's seeing the opposite behavior. In other words, the CDX file is 113MB after all the INSERTs. Then he does a REINDEX and the CDX file reduces in size to 65MB. FWIW, I think REINDEX does erase and rebuild the CDX (though I never use the command personally... I always do a DELETE TAG ALL and INDEX ON).
>

Thanks Brad...you crystallized my question perfectly.

Might have to give you a point for simply reading the actual post carefully, since that seems to be a lost art once in a while here on the UT...

Thanks,
JoeK
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform