My view is as follows:

That VFP7SP1 did not eliminate the bloat caused by record insertions likely resulted in at best marginal improvement of performance regardless of the frequency of REINDEX. Unless an application made 'regular' use of the DELETE TAG (probably infrequent in production aplications) in which case it should be helpful.

That VFP8, at least in its beta incarnations to date, does return to elimination of "record insertion bloat" suggests that what was observed in VFP7SP1 was an unintended consequence of something done (or left undone) in the VFP7SP1 release.

Assuming that VFP8 (whatever it may be called < s >) retains the change observed in the beta, I'd say that regularly REINDEXing is still to be recommended, with extra considerations as regards applications running VFP7SP1.

Some prefer to simply use the REINDEX command while others insist on the combination of DELETE TAG ALL followed by INDEX ON... commands. I think the recommendation applies in either case.

cheers, and Merry Christmas.


>Hi Al,
>
>I've read the threads you're (I think) referring to. The 'discussion' I'm now seeking is whether or not users should be instructed to 'reindex' regularly, for performance reasons. That was not the core of the discussions in the threads I've read. If it was in the thread you're referring to, then I'd appreciate a link.
>
>I wonder whether reindex gives better 'balanced tree structures' and 'physical disk clusters'. Who knows?
>
>>>Hi David,
>>>
>>>In an old thread you say:
>>>
>>>"CDX bloat is something that affects performance. Routine reindexing is prudent for tables that undergo lots of adds and deletes."
>>>
>>>Are you suggesting that a reindexing routine (or a 'delete tag all' followed by various 'index on' commands) should be part of any application that handles tables that have a lot of records added and deleted?
>>>
>>>My hunch is that there's no gain at all. I'm talking now about vfp7sp1. Addition of records will not over-inflate the cdx. And deletion of records will neither inflate nor shrink the cdx. Purging the deleted records with PACK also implies a REINDEX.
>>
>>IIRC this was discussed at length some time ago and yes, .CDX size doesn't vary as much as it used to. However, theoretically a reindex might let VFP better balance any tree structure in the index, and/or arrange physical disk clusters for higher performance. I don't know if VFP actually does any of this.