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