How to Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch

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
  • Test DB Queries with DBTester
  • Do Performance Testing with JMeter
  • Measure Ad Hoc Performance
• 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
  • Index columns in the database to speed up domain-based reports
• JasperReports Configuration Items
  • Modify Virtualizer Settings for Very Large Reports
  • Modify the jasperreports.properties file to disable multi-line data processing

• Back to JasperReports Server Performance Tips and Tricks