Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-6083

Performance degrades when exporting a report to HTML (Paginated) having large Custom Page Layout.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: 7.0.0 GA, 7.1.0 GA, 8.0.0 GA, 8.1.0 GA, 8.2.0 GA, 8.3.0 GA
    • Fix Version/s: Backlog
    • Component/s: Report Generation
    • Labels:
      None
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      1. Upload the report DWH0001_dummydata_modified_70.prpt to the User Console
      2. Execute the report.
      Show
      Steps to replicate the issue: Upload the report DWH0001_dummydata_modified_70.prpt to the User Console Execute the report.

      Description

      A prpt report having a large custom layout defined when exported to HTML (Paginated) takes longer time to generate the report.
      I am attaching a sample report having the custom layout with Width as 18300, Height as 6025 and with Landscape selected.
      When exporting this report to HTML paginate we see the total time taken for exporting is around 9min which includes around 4 min for pagination and another 4:30 min for rendering all pages on the browser. I have tried all the suggestions given in the link https://www.on-reporting.com/blog/performance-monitoring-and-tuning-in/ but there is no improvement in the

      When we reduce the page size we see a considerable improvement in the time taken for the generation of the report.

      I am attaching both the versions of report for your reference. DWH0001_dummydata_modified_70.prpt is the report with custom layout having Width as 18300, Height as 6025.
      DWH0001_dummydata_modified_70_reduced_layout_withallfields.prpt is the report with custom layout with width as 9300 and height as 3000.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              gdev Gurudev
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: