Return-Path: Delivered-To: apmail-commons-user-archive@www.apache.org Received: (qmail 61124 invoked from network); 26 Feb 2009 10:59:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Feb 2009 10:59:52 -0000 Received: (qmail 23688 invoked by uid 500); 26 Feb 2009 10:59:47 -0000 Delivered-To: apmail-commons-user-archive@commons.apache.org Received: (qmail 23630 invoked by uid 500); 26 Feb 2009 10:59:47 -0000 Mailing-List: contact user-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Commons Users List" Delivered-To: mailing list user@commons.apache.org Received: (qmail 23619 invoked by uid 99); 26 Feb 2009 10:59:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Feb 2009 02:59:47 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 64.142.123.30 is neither permitted nor denied by domain of stefano.nichele@gmail.com) Received: from [64.142.123.30] (HELO a.mail.sonomait.com) (64.142.123.30) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Feb 2009 10:59:38 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by a.mail.sonomait.com (Postfix) with ESMTP id BD3E6164821 for ; Thu, 26 Feb 2009 02:59:16 -0800 (PST) X-Virus-Scanned: amavisd-new at X-Spam-Score: -1.295 X-Spam-Level: Received: from a.mail.sonomait.com ([127.0.0.1]) by localhost (a.mail.sonomait.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ioi+WPWBv1kY for ; Thu, 26 Feb 2009 02:59:15 -0800 (PST) Received: from [172.18.30.70] (89-96-142-243.ip12.fastwebnet.it [89.96.142.243]) by a.mail.sonomait.com (Postfix) with ESMTP id 67ACA164817 for ; Thu, 26 Feb 2009 02:59:14 -0800 (PST) Message-ID: <49A675FE.9080503@gmail.com> Date: Thu, 26 Feb 2009 11:59:10 +0100 From: Stefano Nichele User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Commons Users List Subject: Re: [dbcp] poolPreparedStatements parameter References: <49A5BCDC.6080806@gmail.com> <2fb267f80902251542t29241f10sbe30be9b591158fd@mail.gmail.com> <7D3007CC2DAF25499C28D1C0DDE693DAB9CD05@newexchange.guidewire.com> <22221389.post@talk.nabble.com> In-Reply-To: <22221389.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Flag: NO X-Old-Spam-Status: No, score=-1.295 tagged_above=-10 required=5 tests=[AWL=0.518, BAYES_00=-2.599, RDNS_DYNAMIC=0.1, SPF_NEUTRAL=0.686] Thanks for you answer. This is what I think (talking also about your other email). What I don't understand is why it is false by default. Maybe memory usage ? I don't know....I would like to turn on it on production but I'm a bit doubtful. Is there any trab ? Bugs ? Just for completeness I'm using postgres. Curious the fact that the validation query is not a prepared statement....but it should be performed rarely. ste Gamnacke wrote: > I can tell you that a modern database (Oracle 10) does not seem to do a good > job of caching the query. According to snapshots taken on our DB we get a > one-to-one correspondence between query execution and query parsing if we > turn off pooling. With pooling turned on, the query needs only be parsed > once. > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@commons.apache.org For additional commands, e-mail: user-help@commons.apache.org