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!
2 Answers:
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.
