• 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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!