Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How many statements can be cached by hibernate?..

 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends...

i have any question about cached statements in Hibernate...
i have configured hibernate with the properties like the following code :
(which use c3p0 Pooling provider..)


in that properties i set the property "hibernate.c3p0.max_statements" =200..
AFAIK its mean i can save cache 200 statements (PreparedStatements) with hibernate...

How many statements can be cached by hibernate?..

Thanks in advance..
 
Mudit Srivastava
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't think its possible to say what's the maximum number that can be set for this property. I've just seen sample definitions with 100/200 statements set as the max size.
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah.. Thanks Mudit for your reply..

I really doubt about that property..
in fact the application will have much queries..
is it possible to set that property example i will set it to 2000 statements?..

iam using mysql v5 as my DDMS..
as I know DBMS will cached the queries often accessed..

if we use Hibernate.. Does MySQL will cached it also?..
Thank's
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic