Hi John,
>Is there a general rule on how often tables should be packed and reindexed? I have an app with 20+ tables, and four of them are fairly sizeable relative to the others (about 90,000 records). There are many inserts and deletes to these four tables (200+ inserts and 50+ deletes per week).
I let the user enter a percentage of deleted records they accept and then pack automatically when there more deleted records in a table than that. The same applies to the CDX. When its size increased by a certain (configurable) percentage, it's reindexed. The second reason to pack and reindex is when the user experience strange behavior in the application.
Christof
--
Christof