Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance re-index before/after defragmentation?
Message
 
 
To
02/02/2003 12:10:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00748158
Message ID:
00748185
Views:
20
>>Jim,
>>>
>>>2) REINDEX (except in VFP7SP1) will remove CDX "bloat" of both the deleted TAG variety and the 'random inserts causing extra nodes' variety. A smaller file is always better and I should think especially so where it is a .CDX. A REINDEX will also result in a 'contiguous' (as much as available RAM will allow) .CDX file as its output.
>>>
>>
>>You're confusing index size with index bloat. REINDEX command in any version of VFP will remove index bloat.
>
>Well I'd like to know how you can conclude that with the evidence at hand. I have shown that a VFP7SP1 REINDEX does not shrink the CDX, nor grow it (by any more than 512 bytes and only in some cases).
>In this case, how can you be so sure that "bloat" is removed????

In part, based on your tests posted at http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP. See #7. I quote "CDX size is reduced in all releases".
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform