Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 74439 invoked from network); 20 Dec 2008 15:00:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Dec 2008 15:00:34 -0000 Received: (qmail 31496 invoked by uid 500); 20 Dec 2008 15:00:34 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 31484 invoked by uid 500); 20 Dec 2008 15:00:34 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 31473 invoked by uid 99); 20 Dec 2008 15:00:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 20 Dec 2008 07:00:34 -0800 X-ASF-Spam-Status: No, hits=4.0 required=10.0 tests=DNS_FROM_OPENWHOIS,FORGED_YAHOO_RCVD,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 20 Dec 2008 15:00:25 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LE3JE-0005m1-L5 for user@cayenne.apache.org; Sat, 20 Dec 2008 07:00:04 -0800 Message-ID: <21105729.post@talk.nabble.com> Date: Sat, 20 Dec 2008 07:00:04 -0800 (PST) From: KathyS To: user@cayenne.apache.org Subject: Re: query_governor_cost_limit setting not working with cayenne? In-Reply-To: <7CEB3A3A-01F0-447B-90CE-07717F1001C5@objectstyle.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: scarletkathy@yahoo.com References: <21099002.post@talk.nabble.com> <77FB38E5-7E1D-490C-B841-EEE0A8323AFB@objectstyle.org> <21105642.post@talk.nabble.com> <7CEB3A3A-01F0-447B-90CE-07717F1001C5@objectstyle.org> X-Virus-Checked: Checked by ClamAV on apache.org Prepared vs plain statement may change execution plan for the governor query itself, but as long as it runs, and I verified it runs by watching sql server trace, it should "work". I was more concerned seeing sp_prepare / sp_unprepare surrounding each query, even inside of the chain. Andrus Adamchik wrote: > > > On Dec 20, 2008, at 4:48 PM, KathyS wrote: > >> JDBC code is straightforward: >> Statement stmnt = con.createStatement(); >> stmnt.execute("SET query_governor_cost_limit 2"); > > The only difference with Cayenne internal execution path would be that > Cayenne will use PreparedStatement here. Anyways, I need to try it I > guess... > > Andrus > > > -- View this message in context: http://www.nabble.com/query_governor_cost_limit-setting-not-working-with-cayenne--tp21099002p21105729.html Sent from the Cayenne - User mailing list archive at Nabble.com.