Chapter 16. Performance Tuning

Table of Contents

Analysing performance problem
Iterating through relations – batches
Iterating through relations – subqueries
Iterating through relations – single query
Reporting queries
Iterating through large resultsets
EH Cache
OS Cache
Bypass a cache

There is a incredible choice of options to improve the performance of Hibernate based application. This chapter describes quite a number of them. Each part starts with a small use case describing the problem or requirement. After this you will find a detailed solution how to solve the problem.

Source code for the samples can be found in the project mapping-examples-annotation. Have a look in the package de.laliluna.other.query.

Some of the use cases make use of the following class structure:


Analysing performance problem


If a dialog is too slow, there might happen a lot of unexpected queries. This can be caused by eager loading of relations or you might just reuse the queries of another dialog. Did you know for example that 1:1 and n:1 relations are loaded eagerly, if you use annotations whereas XML mappings are lazy by default.


The best approach is to analyse what is happening behind the scenes. Hibernate offers two configuration settings to print the generated SQL. The first one is a property in the hibernate.cfg.xml

<property name="show_sql">true</property>

If it is set to true, the SQL statements will be printed to the console. You will not see any timestamps, this is why I prefer the second approach, which uses the normal logging output.

# logs the SQL statements

# Some more useful loggings
# Logs SQL statements for id generation
# Logs the JDBC-Parameter which are passed to a query (very verboose)
# Logs cache related activities

There are more useful settings in the Hibernate configuration hibernate.cfg.xml

The property format_sql will nicely format the SQL instead of printing it on a single line.

<property name="format_sql">true</property>

The property use_sql_comments adds a comment to each SQL explaining why it was created. It let’s you identity if a HQL statement, lazy loading or a criteria query led to the statement.

<property name="use_sql_comments">true</property>

Another good source for information are the statistics of Hibernate.

You can enable the statistics in the Hibernate configuration or programmatically. The statistics class offers a number methods to analyse what has happened. Here a quick example:

Statistics statistics = sessionFactory.getStatistics();

Furthermore you can call getStatistics on a session as well to gather information about it.