tomcat-users mailing list archives

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

Ran,

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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFgM7I9CaO5/Lv0PARAtmSAKCv2mWhH+01QmVpFTMHBhIBVtF8WgCfSdj/
8BtCwGvSBJmvbRZI18ZxYKk=
=FvJ5
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message