Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detect CDX Bloat
Message
 
 
À
08/02/2004 04:17:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00875209
Message ID:
00875270
Vues:
18
Fabio,

There is no real way to calculate it from VFP's perspective. Since the CDX uses run-length encoding in it's compression of the keys the size is dependent on the the actual data in the table.

I think the best you can do is to track the DBF vs CDX size for each table when the CDX is first created and then monitor the changes and reindex when a threshold limit is exceeded.

>With PACK ( it copy the DBF,FPT and recreate CDX) the solution is simple, but i want use this shema:
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform