Performance issue while loading 1,6 mil records

0

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!

ana.vitu_1's picture
Joined: Mar 26 2019 - 2:45am
Last seen: 10 months 3 weeks ago

2 Answers:

0

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.

hozawa's picture
57650
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
0

Another topic is on datasource type. Beans are really slow. I've found jdbc and csv to be the fastest.

hozawa's picture
57650
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
Feedback