How to tune the number of connections in the server database pool

Tune the number of connections in the server database pool

You can tune several attributes of the repository database connection pool to improve performance. There are three resources specified:

Probably you will only be interested in tuning the jdbc/jasperserver resource. If you're running SugarCRM you might be interested in that resource. The foodmart entry is specified for a sample that is shipped with the Server. Those two entries are examples of connection pools setup for JNDI Datasources.

You can set these values in the context.xml file, which you can find in the /jasperserver-pro/META-INF directory.

Modify the object you want to tune, adding or modifying the attributes according to your needs.

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
  • 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
  • Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch
• 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