Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 48751 invoked from network); 14 Dec 2006 04:09:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Dec 2006 04:09:31 -0000 Received: (qmail 19166 invoked by uid 500); 14 Dec 2006 04:09:27 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 19131 invoked by uid 500); 14 Dec 2006 04:09:26 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 19119 invoked by uid 99); 14 Dec 2006 04:09:26 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 20:09:26 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [63.240.77.82] (HELO sccrmhc12.comcast.net) (63.240.77.82) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 20:09:15 -0800 Received: from [192.168.1.47] (c-69-143-26-154.hsd1.va.comcast.net[69.143.26.154]) by comcast.net (sccrmhc12) with ESMTP id <20061214040851012004ilipe>; Thu, 14 Dec 2006 04:08:51 +0000 Message-ID: <4580CEC8.7070108@christopherschultz.net> Date: Wed, 13 Dec 2006 23:10:48 -0500 From: Christopher Schultz User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Tomcat Users List Subject: Re: [tomcat 5.0] - DBCP pooling vs sharing a single open connection References: <457DB4B0.6000008@aspix.it> <457ECBA0.2000303@christopherschultz.net> <45801F9E.6050702@christopherschultz.net> In-Reply-To: X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org -----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