I am using C3P0. i have below configuration. i need to cache the statements.
maxPoolSize="20"
minPoolSize="6"
acquireIncrement="3"
initialPoolSize="3"
maxStatements="2000"
here i have set maxStatements to 2000. maxPoolSize is 20. does it mean total 2000*20=40000 statements wil be cached?
Thanks!
no maxStatements is the global cache max size.
maxStatementsPerConnection is the per connection value.
Relevant section the c3p0 docs
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With