Hibernate cache and MySql query cache

Question

Caching is all about application performance optimization and it sits between your application and the database to avoid the number of database hits as many as possible to give a better performance for performance critical applications.

I have ability to use Hibernate cache and MySql query cache.

What mechanism should i choose ? Or may be i should use both of them to rich maximum performance (and maximum RAM usage :D) ?

It will depend on your application. I tend to use none of them and load the data in an external cache library like ehcache or infinispan. — Luiggi Mendoza
– Luiggi Mendoza, Commented May 7, 2014 at 20:38
@Luiggi Mendoza, Hibernate uses ehcache (one of possible variants) as external cache provider. — Vololodymyr
– Vololodymyr, Commented May 7, 2014 at 20:40
I know, still from my tests I don't trust it and use it as external component instead of using it next to hibernate. — Luiggi Mendoza
– Luiggi Mendoza, Commented May 7, 2014 at 20:41

Sireesh Yarlagadda · Accepted Answer · 2014-05-07 21:36:39Z

1

We have two ways of Cache in Hibernate.

1) Memory (RAM)

2) Disk (HD)

Since you are trying to save the RAM, please try to create the cache in the disk.

Use the DiskStore option in the EnCache.

<cache>
   <persistence strategy=”localRestartable|localTempSwap|none|distributed” synchronousWrites=”false|true”/>
</cache>

If you are using Java 7 and plus.

Go for BigMemory for the best performance.

edited May 7, 2014 at 21:36

answered May 7, 2014 at 21:23

Sireesh Yarlagadda

13.9k3 gold badges78 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate cache and MySql query cache

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related