Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch
In the jasperreports.properties file you can set net.sf.jasperreports.jdbc.fetch.size=n, where n is the number of rows to fetch at a time - optimizing this can reduce the number of trips to the database.
For instance, if this value isn't set, Oracle uses a default value of 10 and DB2 uses 32 - by setting it to something higher, like 1000, you could conceivably reduce the round-trips to the database by more than two-thirds.
Other Performance Tips:
Measure and Test
Ad Hoc
- Set query limits on the "Ad Hoc Options" page
- Modify the Ad Hoc caching values if your data does not update constantly
Tomcat
- Compress HTTP responses at the Tomcat level
- Increase the maximum thread count at the Tomcat level
- Set up a cache filter for Tomcat or JBoss
- Disable automatic deployment on production servers using Tomcat
Database
JasperReports Configuration Items
- Modify Virtualizer Settings for Very Large Reports
- Modify the jasperreports.properties file to disable multi-line data processing
Recommended Comments
There are no comments to display.
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