Support Article
Low system performance when a class has four billion records
SA-54491
Summary
The class rule requires 600 seconds to load when the system holds a class which contains four billion records.
Error Messages
Class record is taking a long time to load
Steps to Reproduce
- Create a data class
- Map the data class to a table from the database using the data admin database table
- Insert four billion records in the table
- Open the Pega Dev portal
- Open the class rule form
Root Cause
A defect in Pegasystems’ code or rules. The query is changed such that instead of executing a query using count(*), a different style of the query is executed.
Resolution
Perform the following local-change:
Customize the RULE-OBJ-ACTIVITY RULE-OBJ-CLASS ONBEFOREDISPLAY activity rule which is available by modifying a local copy of the rule such that it does not use the select count(*) query, but selects a random value (character X) and limits the results to one.
Published August 19, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.