Return-Path: Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 96392 invoked from network); 24 Apr 2003 17:37:59 -0000 Received: from taz.merck.com (HELO usryim00) (155.91.6.20) by daedalus.apache.org with SMTP; 24 Apr 2003 17:37:59 -0000 Received: from 155.91.2.6 by usryim00 with ESMTP (SMTP Relay (MMS v5.5.2 )); Thu, 24 Apr 2003 13:39:57 -0400 Received: from usrygw04.Merck.Com (usrygw04.merck.com [54.3.102.185]) by mmh1.merck.com (PMDF V6.0-24 #37353) with ESMTP id <01KV3TO9SV2S00BGUF@mmh1.merck.com> for commons-user@jakarta.apache.org; Thu, 24 Apr 2003 12:37:53 -0500 (EST) Received: by usrygw04.merck.com with Internet Mail Service (5.5.2656.59) id <2DQ15M5Q>; Thu, 24 Apr 2003 13:37:53 -0400 Content-return: allowed Date: Thu, 24 Apr 2003 13:37:43 -0400 From: "Timko, Cheryl A." Subject: RE: [DBCP] Slow Performance Under Load To: "'Jakarta Commons Users List'" Message-ID: <3FBAE6711D6FD511B5B200508B5C783707F499D9@uswpmx14.merck.com> MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) X-WSS-ID: 12B6FEE7927180-04-01 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N I have DBCP configured to use the default configuration where: driverClassName=oracle.jdbc.driver.OracleDriver url=jdbc:oracle:thin:@xxxxx:25000:mytestdb Username=xxx Password=xxx defaultAutoCommit=true defaultReadOnly=false validationQuery=SELECT SYSDATE FROM DUAL logAbandoned=false removeAbandoned=false removeAbandonedTimeout=300 maxActive=8 maxIdle=8 maxWait=-1 minEvictableIdleTimeMillis=1800000 timeBetweenEvictionRunsMillis=-1 numTestsPerEvictionRun=3 testOnBorrow=true testOnReturn=false testWhileIdle=false whenExhaustedAction=1 Can you recommend more optimal configuration values? Thanks in advance for your help! - Cheryl -----Original Message----- From: Rodney Waldhoff [mailto:rwaldhoff@apache.org] Sent: Thursday, April 24, 2003 1:26 PM To: Jakarta Commons Users List Subject: RE: [DBCP] Slow Performance Under Load Performance will vary widely depending upon your configuration. Can you describe it is you are doing? - Rod On Thu, 24 Apr 2003, Timko, Cheryl A. wrote: > I was hoping someone can help... > > We are performing load testing on both the DBCP and our "custom" database > connection pool. What we found is that when 300 concurrent users are > accessing the DBCP, the response time average is 8 sec. When we run the > same test using our "custom" pool, the average response time is 2 sec. > > Has anyone experienced issues with the performance of the DBCP under load? > > > Your feedback is greatly appreciated... > > > - Cheryl > --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org ------------------------------------------------------------------------------ Notice: This e-mail message, together with any attachments, contains information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that may be confidential, proprietary copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named on this message. If you are not the intended recipient, and have received this message in error, please immediately return this by e-mail and then delete it. ------------------------------------------------------------------------------