Links may not function; however, this content may be relevant to outdated versions of the product.
Managing table turnover rates
Table turnover rates indicate the load on your database and impact performance.
The following tables normally have the highest rate of insert, update, and delete operations:
pr_sys_locks– Locked recordspc_history_work– Work item historypc_assign_– Assignments
The following tables normally have a low rate of insert, update, and delete operations:
pr_other– Empty unless your system has instances of classes without an associated Data-Admin-DB-Table instance.pr4_rule_– Rulespr4_base– Foundation rules
Previous topic Starting the archival process Next topic Counting the rows in a database table