We are using Pega 7.2 with SQL Server, when ever we are clicking "My Reports" it is taking close to 100 seconds to load the reports harness. Upon doing performance analysis, found that the OOTB reports pzRBCategoryShortcuts and pzRBAllCategories taking more than 80 seconds. I believe the Filter by rule resolution check box in these reports might be causing this issue.
Did any one of you faced similar issue?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
If updating the statistics has worked and subsequently the issue re-appears, it means that the statistics are not up to date causing this slowness. You should try and work with your DBA to see how this can be done at regular intervals to keep better performance.
I feel the Reports which Pega product provides looks beautiful but they lack performance target.... no one will wait several minutes to see. I am not sure why Pega product team is not focusing much about improving Reporting performance relates issues. Even there OOB reports performs poor in production when records count grow in million's. Ideally for OOB report what ever indexes they need for OOB columns should have come with Product itself ??