Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Generating a report is server goes much slower than in PRD

  1. #1
    Join Date
    Oct 2017
    Posts
    2

    Default Generating a report is server goes much slower than in PRD

    Hello everyone:

    I have a report taht was made with PRD 3.8 and the migrated to version 7.1 with PRD 7.1.0.0-12 Generating this report in PRD 7.1.0.0-12 takes aproximately 40 seconds.

    I've made an spring-boot-aplication with pentaho-report-engine, using also version 7.1.0.0-12 and generating the same report in the same machine takes aproximately between 7 and 9 minutes.

    The databse is postgresql and using same library version both in PRD and Tomcat.
    Tomcat version is 7.0.55.
    Connections to database are made via JNDI.

    Can use please help me figuring out which what is taking so long in the server?

    Thanks in advance.

  2. #2
    Join Date
    May 2016
    Posts
    282

    Default

    Do you have parameters with list of values associated in your report? I found out that the BI Server when opening a report loads in memory/cache this values and soon the performance is degraded, so I had to reduce the number of List of values in the parameters. Try adding List of Values one at a time, to see how many you can add.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.