Skip to main content
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.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us