Quick Way to Measure Ad Hoc Performance
To get a quick idea of where the bottle neck might be, take a look at Manage => Ad Hoc Cache (logged in as superuser). There are two columns, Query and Fetch:
| Value | Description |
| Query (msec) | time from when query was sent to the db until the first row was received. If this is slow then you should index better (see Index columns in the database to speed up domain-based reports below) |
| Fetch (msec) | Time from when first row was received until the last row was received. If this is slow there might be a network bottleneck. (see Set the fetch size in the jasperreports.properties file to modify the number of rows to fetch below) |
Other Performance Tips:
- Measure and Test
- Ad Hoc
- Tomcat
- Database
- JasperReports Configuration Items
Log in or register to post comments
