Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Single Pass Reindexing
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00505581
Message ID:
00505833
Vues:
27
>>There are two problems:
>>
>>- CDX bloat. If you simply REINDEX, the new tags will be appended to the end of the CDX file. You need to DELETE TAG to remove the space, but then, REINDEX won't work.
>>- REINDEX relies on the tag information stored in the header of the CDX. If this is corrupted, the index will be too or VFP won't be able to read the information. In this case you may have to delete the CDX to build the indeces.
>
>Thanks, I wasn't aware of the bloat issue. When corruption occurs, I replace the CDX with an empty one (stored in my DBC's User field) then issue reindex. This has corrected every corruption that I've run into.


That's a great idea.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform