ana.vitu_1 Posted March 26, 2019 Share Posted March 26, 2019 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 More sharing options...
hozawa Posted March 27, 2019 Share Posted March 27, 2019 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 More sharing options...
hozawa Posted March 31, 2019 Share Posted March 31, 2019 Another topic is on datasource type. Beans are really slow. I've found jdbc and csv to be the fastest. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now