PMFJI. There's interesting information about CDX bloat at
http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP.
>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.
--sb--