hey, i just had question since there are tons of data and whenever i am trying to get data from report defintion and for column summary when i click count distinct or check mark remove duplicates, the case takes way too long due to aggregatng the data so here i am wondering if here somebody can help me. The Report times out before its able to fetch data, i have set timeout to 30 sec i dont want to extend the time i just want it to become faster and load report before 30 sec
@AmandipS1302 your first port of call is to check the pegaALERT logs. Narrow down what type of report you are running and whether you need to fetch that amount of data in the first place.
If you run the same SQL that you see in the DBTrace directly against the database do you see the same performance times as when running it in Pega?
Once you identify the bottlenecks you can work on modifying it. ie evaluate the join conditions, wrong join can cost a lot on the SQL performance.
Please check the following resources:
Performance Issue with My Reports
Configuring rules to improve report performance