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.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
