Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: VFP7 SP1 REINDEX no longer removes BLOAT from .CDX
Message
 
 
To
02/05/2002 15:17:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00652071
Message ID:
00652230
Views:
20
Jim,

>Then I revised the first program to create the indexes while the records were being written. This run produced a .CDX of 88,113,152 bytes according to FSIZE().
>The REINDEX program on this table resulted in a .CDX size of 88,145,920. This is bigger than the pre-reindex .CDX!!!!!


Do you really think a 32k (0.037189%) file size increase warrants 5 exclamation marks? Surely you understand the way B+Trees are created, and the fact that a couple more pages were allocated by the difference in the way the two different trees were constructed should be within reasonable expectation.

Please note I'm not disputing the valid part of the bug report about the near doubling of index size. I can tell you that MS is aware of this !!!!! worthy problem.
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