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 records -
pc_history_work– Work item history -
pc_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_– Rules -
pr4_base– Foundation rules