Low system performance when a class has four billion records
The class rule requires 600 seconds to load when the system holds a class which contains four billion records.
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
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.
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.