{"id":644,"date":"2010-09-23T22:47:02","date_gmt":"2010-09-24T04:47:02","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/?p=644"},"modified":"2010-09-23T22:47:02","modified_gmt":"2010-09-24T04:47:02","slug":"turning-on-hibernate-query-caching","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/644","title":{"rendered":"Turning on hibernate query caching"},"content":{"rendered":"

Sometimes I write a blog post because I want to say something to others, other times because I want to help others, and sometimes I write one for myself.\u00a0 This is one of the latter type of posts.<\/p>\n

I find that nothing drives home a lesson I learned like writing out the solution on my blog, and more than one time I’ve searched my blog because I remember I had written about a topic of current interest in the past.<\/p>\n

If you want hibernate, a java ORM tool, to cache your query results, there’s a section in the hibernate manual<\/a>. Like most of the hibernate documentation, it’s quite good.\u00a0 One thing that caught me up, though, is that I thought that all queries were cached, as soon as you had set up the correct configuration in your hibernate xml files and marked your objects as cacheable.<\/p>\n

However, this is not the case,\u00a0 as I learned when I turned on the mysql query log<\/a> and looked at the calls the interesting web application was making.\u00a0 I did quite a bit of searching, but the answer was in the same section<\/a> that told me how to set up the configuration (as well as in this forum post<\/a>).<\/p>\n

…most queries do not benefit from caching or their results. So by default, individual queries are not cached even after enabling query caching. To enable results caching for a particular query, call org.hibernate.Query.setCacheable(true)<\/code>.<\/a><\/p><\/blockquote>\n

Doh!\u00a0 Following these instructions decreased the page load time for some heavy query pages from 8 seconds to 0.5 seconds (the second time the page was loaded).\u00a0 Impressive indeed, though the production environment might not see such drastic improvements.<\/p>\n

One additional note–you can use query caching for SQLQueries (like group operations) by telling hibernate what the type is of each returned value.\u00a0 If you don’t use addScalar, but you do mark a SQLQuery as cacheable, you’ll get a java.lang.ArrayIndexOutOfBoundsException when that code executes.\u00a0 More here<\/a>.<\/p>\n

These articles were helpful to me as I navigated Hibernate caching, above and beyond the reference documentation:<\/p>\n