0

Our application handles read-only data, so we are considering using Hibernate query cache features (implemented by ehcache) on all queries.

So far we enabled both second level and query caches:

<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>

And then told hibernate that each query was cacheable:

query.setHint("org.hibernate.cacheable", true);

I can identify two drawbacks from this approach:

  • code redudancy (as you have to manually add the hint for each query)

  • hibernate dependency (so far the code is clean from direct
    hibernate references, using only JPA annotations)

Is there any way to achieve this, i.e. caching all queries, using only configuration files?

Thank you!

Paul Podgorsek
  • 2,416
  • 3
  • 19
  • 22
Pierre Duplouy
  • 2,415
  • 5
  • 23
  • 24

2 Answers2

1

No, there is not, because that would not make much sense (or better said, it would not be useful in 99.99% of the use cases).

There is always a different entry in the cache for each combination of the query and the input parameters (bind variables).

The query cache should be enabled for queries which select from entities (tables) that are changed (inserted into, updated, deleted from) rarely and for which there will not be a large number of combinations of different input parameters.

Dragan Bozanovic
  • 23,102
  • 5
  • 43
  • 110
  • Thanks, I agree with what you're saying. I guess we are dealing with one of the few application for which such a feature would be useful. – Pierre Duplouy Jul 22 '15 at 13:34
0

It makes sense in my app to be able to cache all queries. I have an application so big, and old, that it end-up to duplicate lot of queries even during the same transaction. That app will run way faster and use not much more memory if it could cache query result of all queries during the request. Let say to simplify, I set the cache for 10 seconds, then I will get my application to be significantly faster.

Sebastien Tardif
  • 337
  • 3
  • 9