SA-28122

Summary

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.
 

Resolution

 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.