On 07/11/2013 16:08, Christopher Schultz wrote: > Mark, > > On 11/7/13, 11:03 AM, Mark Thomas wrote: >> On 07/11/2013 15:58, yogesh hingmire wrote: >>> While looking to upgrade to tomcat7, i understand the >>> connection pool is a major improvement. I read that >>> >>> commons-dbcp is single threaded, in order to be thread safe >>> commons-dbcp locks the entire pool, even during query >>> validation. > >> Where did you read that? While it might have been true of >> earlier DBCP releases I'm fairly sure it is not true for current >> releases. > > http://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html#Introduction > > http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html#Introduction > > Bullet-point #1 in both cases.
Yep. Over 4 years out of date. I've made some edits. The key messages are: - jdbc-pool is faster than Commons DBCP - at low concurrency there is little between them - as concurrent borrow()s and return()s increase, the differential increases - how much difference it makes depends on the app so as with any performance optimisation, test it first - Tomcat 8 with DBCP2 should be a lot closer to jdbc-pool irrespective of concurrency but I still expect jdbc-pool to be faster Mark --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
