General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only