Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: VFP7 SP1 REINDEX no longer removes BLOAT from .CDX
Message
From
07/05/2002 13:01:13
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00652071
Message ID:
00653624
Views:
13
>Hi Dragan,
>
>I updated the wiki to make clearer what part I had added to David's great posting.
>
>>I assume the calculus involved there, regarding the number of keys per node, is only approximate
>
>Yes, of course. The number of keys per node depends on the size of the compressed keys as well as the number of records in the table. It's just an example to explain the different results and what changed from previous versions.
>
>Christof
Christof,

I've read the Article on Wiki that David started and you added to. It's great to have all of that information in a single place.

Allowing that THIS thread has as its focus the bloat caused by index node splitting and the like (deleted TAG bloat exists, of course, but that is likely a very rare event in production systems and their larger tables), I surmise that VFP7SP1's REINDEX command simply no longer has any of that kind of bloat to eliminate. Thus the differences in my observations between VFP6SP5 (and FPD 2.6?) and VFP7SP1.

Is that a correct interpretation?
Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform