commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gamnacke <gamna...@yahoo.se>
Subject RE: [dbcp] poolPreparedStatements parameter
Date Thu, 26 Feb 2009 10:24:20 GMT

I can tell you that a modern database (Oracle 10) does not seem to do a good
job of caching the query. According to snapshots taken on our DB we get a
one-to-one correspondence between query execution and query parsing if we
turn off pooling. With pooling turned on, the query needs only be parsed
once.

-- 
View this message in context: http://www.nabble.com/-dbcp--poolPreparedStatements-parameter-tp22212678p22221389.html
Sent from the Commons - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message