Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Poor performance on a specific report (80 Seconds)



One of the report took 80 seconds to render the information in UI.

The performance issue does not come from the Database but there is a spike in the CPU usage and expecting that there is an issue or limitation within the report definition or the rendering of the information in the report definition.

Error Messages

Not Applicable

Steps to Reproduce

This report is displayed as a chart from a Manager Portal.

 Step 1: Login to Portal.
 Step 2: Select Charts option. Four charts are displayed. Note that the chart as displayed here (without the data in table below chart) does not have the issue.
 Step 3: Select Chart Actions > Show Data.
 Step 4: Wait up to 80 seconds to render the data.


Root Cause

The root of the problem is that the third column configured on the report has the "Display values across columns" option selected, and as a result numerous columns are being rendered.
The performance hit is not seen when only the chart is displayed, only when the grid is rendered.  This is because the loss in performance is due to the grid rendering, which is obvious from the tracer data.


 This is probably expected behavior, the performance degrades when the number of rows, the number of columns, and the number of groups (columns in the report that do not have a summarize function set) rise.

In other words, the more data being displayed, the longer it will take to display it. 

Published September 21, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us