Hibernate Community • View topic - Cache size in QueryPlanCache

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Cache size in QueryPlanCache

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

JulienKirch

Post subject: Cache size in QueryPlanCache

Posted: Tue Mar 18, 2008 11:28 am

Newbie

Joined: Thu Mar 01, 2007 6:08 am
Posts: 3

Hibernate version: 3.2.6

Hi,

on a large application with many (currently 696) named queries in hbm files we have a performance issue with the QueryPlanCache cache size:

the SoftLimitMRUCache used in the QueryPlanCache has 128 hard references, the other being soft references, and this number is hardcoded. As we have much more querries in the application, we spend much time in recompiling the same queries when they are evicted from the cache.

As the QueryPlanCache has a SessionFactoryImplementor as parameter, adding a new parameter to define the query cache plan size would trivial; what's your opinion anout this ?

Top

llefevre

Post subject: 128 should be enough for anybody ;o)

Posted: Wed Mar 19, 2008 6:01 am

Newbie

Joined: Tue Mar 11, 2008 6:41 pm
Posts: 8
Location: France

I'm looking forward for an answer to this question too :)

Also, maybe some "pin" this query plan forever could be some solution.

Anyway, if we have RAM, why this limit for 128?

Regards,
LL

ps: http://www.theinquirer.net/en/inquirer/ ... nybody-not

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum