Jump to content
Changes to the Jaspersoft community edition download ×

Performance issue while loading 1,6 mil records


Recommended Posts

I'm facing a Jaspersoft performance issue while running a simple report that is loading 1,6 mil records.

I created input control options that always prompt before executing the report.

When executing the report, it takes 4 minutes to display the filters and another 4 minutes to load the data. If I run the same query in Athena (my ETL layer), the running time is only 5 seconds.

Does anyone have an idea how I could improve the performance? This issue is critical for end users.

Thank you in advance for your help!

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

JasperReports Server has a major performance problem with large data set. If you've tuned your database query, the other remaining option beside customizing JasperReports Server itself is to increase memory.


The other option is to just write a simple program using JasperReports library to generate the reports.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...