Retrieving data using report definition became very slow due to hot fixes
We are using Pega product for migration from Old POD tables to POA system (Pega Work objects).
We use to have 8000 policies per hour before May this year.
After recently these hot fixes installed, the count has been dropped from 8000 to 4000 policies per hour.
below are the hotfixes :
HFIX-27767 HFIX-62248 HFIX-32457 HFIX-63340 HFIX-33066
We use cascading data pages with report definition to pull the data from data tables and use to create policy work object.
So we observed recently our performance report for retrieve data has been increased from 6.5 secs to 15 secs processing time.