C3P0 max instruction configuration?

Question

I am using C3P0. I have below configuration. I need to cache statements.

maxPoolSize="20" 
minPoolSize="6" 
acquireIncrement="3"
initialPoolSize="3"
maxStatements="2000"

here i installed maxStatementsin 2000. maxPoolSize- 20. Does this mean a total of 2000 * 20 = 40,000 statements to be cached?

Thank!

+5

user1016403 Feb 26 '13 at 10:57

1 answer

Gareth davis · Accepted Answer · 2013-02-26T11:05:32+0000

no maxStatementsis the maximum size of the cache cache.

maxStatementsPerConnection is the value for each connection.