Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect CDX Bloat
Message
 
 
To
08/02/2004 04:17:32
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00875209
Message ID:
00875270
Views:
17
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform