tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thomas <ma...@apache.org>
Subject Re: DBCP is Single Threaded
Date Thu, 07 Nov 2013 16:36:14 GMT
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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message