Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindexing prudent?
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00735440
Message ID:
00735724
Views:
7
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform