Why Hibernate 4 could be faster than JdbcTemplate?

Question

I have a project with Spring 4 and Hibernate 4 as JPA. And I have a DAO-layer bean with method like:

@Transactional
public MyDtoObject getDataWithALotAggregation(String params){
 String queryStr = "select aLotAggregatedData from aLotJoinedTables where aLotParams="+params;
Object[] rawData = sessionFactory
  .getCurrentSession()
  .createSQLQuery(queryStr)
  .uniqueResult();
return mapRawDataToMyDtoObject(rawData);
}

and I just compared timing of this method with timing of jdbcTemplate.queryForObject(queryStr, mapper, params) and I got surprised that Hibernate is bit faster than JDBC API (~5-10%).

Any idea why Hibernate is faster or JdbcTemplate so slow?

I was sure that Hibernate especially with transactions should be slower than JdbcTemplate...

Use a profiler, measure time of your code and you will see where a program spends time. I think no one can aswer your question, that's guessing. — krokodilko, Jun 21 '19 at 17:15
see this question. https://stackoverflow.com/questions/11791145/spring-jdbctemplate-vs-hibernate-in-terms-of-performance another link : https://stackoverflow.com/questions/17301122/differences-between-spring-jdbctemplate-and-hibernate/17301317 — Karim M. Fadel, Jun 21 '19 at 18:14

score 1 · Answer 1 · answered Jun 21 '19 at 18:46

The reason why it is slower most likely because query generated by hibernate is different than yours.

My guess is that your code has this .uniqueResult();, which checks for duplicate objects. The bigger the dataset is, the more you will feel it in your case. However, it might be the number of columns mapped. The more columns are requested, the slower the response is.

Why Hibernate 4 could be faster than JdbcTemplate?

1 Answers1