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