Hibernate version: 3.2.5.ga
Name and version of the database you are using: Mysql 5.0

I have been Doing performance testing of my application. And i am looking at the stats generated by org.hibernate.stat.Statistics to look at the stats.

It seem like the query cache is not used at all. Even for same equeries that get executed more than 1000 times the Cache put and hit count are zero!

Whats wrong ? Are the stats correct? Or i am not using Query cache at all? FI not Why?

My Hibernate is configured like :





Any sort of help will be appreciated.

Thanks,

Pike

OK i even tried adding following property:

<property name="hibernate.cache.use_query_cache">true</property>

Now a few qeries are cached but 98% are not even put in the cache. Why only couple of qeries are put in the query cache?

did you use in your Java code ?

Are you set up to generate statistics? I am using Spring and needed to add <prop key="hibernate.generate_statistics">true</prop>
to my hibernate properties

Are you set up to generate statistics? I am using Spring and needed to add <prop key="hibernate.generate_statistics">true</prop>
to my hibernate properties

Are you set up to generate statistics? I am using Spring and needed to add <prop key="hibernate.generate_statistics">true</prop>
to my hibernate properties