LinkedIn
Copied!

Table of Contents

Managing table turnover rates

Version:

Only available versions of this content are shown in the dropdown

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
Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.