tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <>
Subject Re: [tomcat 5.0] - DBCP pooling vs sharing a single open connection
Date Thu, 14 Dec 2006 04:10:48 GMT
Hash: SHA1


Ran wrote:
> Would the expensive opening database connection a issue while using Named
> Pipes ?
> (is the cost mostly coming from TCP 3 way or the xact setup/resource
> allocation on the db side for a new inbound connection ?)

I don't think that named pipes versus sockets is much of a difference.
The real problem is that the database itself has to do a lot of work to
set up the connection on it's side (buffer allocation, etc.). Some
databases are faster than others. MySQL is very speedy when establishing
new connections, whereas Oracle (at least in the past) takes forever.

If you are using SSL to communicate with your database over TCP/IP (and
though you indicated that you are /not/, I figured I'd mentioned it),
then there is a still higher cost associated with establishing the
connection. But, I think the cost is really dominated on whatever the
database server itself has to do, rather than the actual setup of the
"connection" itself.

Hope that helps,
- -chris

Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla -


To start a new topic, e-mail:
To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message