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 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