Return-Path: Delivered-To: apmail-cayenne-dev-archive@www.apache.org Received: (qmail 14025 invoked from network); 28 Dec 2009 14:21:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 28 Dec 2009 14:21:53 -0000 Received: (qmail 5163 invoked by uid 500); 28 Dec 2009 14:21:53 -0000 Delivered-To: apmail-cayenne-dev-archive@cayenne.apache.org Received: (qmail 5120 invoked by uid 500); 28 Dec 2009 14:21:53 -0000 Mailing-List: contact dev-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list dev@cayenne.apache.org Received: (qmail 5110 invoked by uid 99); 28 Dec 2009 14:21:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 28 Dec 2009 14:21:53 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 28 Dec 2009 14:21:45 +0000 Received: (qmail 13950 invoked from network); 28 Dec 2009 14:21:23 -0000 Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1) by localhost with SMTP; 28 Dec 2009 14:21:23 -0000 Message-Id: <58550655-D640-40C1-867C-CEEEB452E10D@objectstyle.org> From: Andrus Adamchik To: dev@cayenne.apache.org In-Reply-To: <3219fff70912280615q23c2fb0dw325fd1033307608@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: [jira] Created: (CAY-1349) SelectQuery 'fetchSize' setting is not propagated to disjoint prefetches Date: Mon, 28 Dec 2009 16:21:22 +0200 References: <460020609.1262009369397.JavaMail.jira@brutus.apache.org> <3219fff70912280615q23c2fb0dw325fd1033307608@mail.gmail.com> X-Mailer: Apple Mail (2.936) X-Virus-Checked: Checked by ClamAV on apache.org I've no idea what performance hit we'll take by enabling this setting. Looking at MySQL driver code I have a suspicion it may slow down smaller queries, as it switches to the "streaming mode" if the fetch size is enabled.. So one size may not fit all here. I'd say this needs to be researched more. Andrus On Dec 28, 2009, at 4:15 PM, Andrey Razumovsky wrote: > Would not it be better if we also had application-scoped statement > fetch > size? After all, this is a way to decrease memory payload > > 2009/12/28 Andrus Adamchik (JIRA) > >> SelectQuery 'fetchSize' setting is not propagated to disjoint >> prefetches >> ------------------------------------------------------------------------ >> >> Key: CAY-1349 >> URL: https://issues.apache.org/jira/browse/CAY-1349 >> Project: Cayenne >> Issue Type: Bug >> Components: Cayenne Core Library >> Affects Versions: 3.0RC1 >> Reporter: Andrus Adamchik >> Assignee: Andrus Adamchik >> Priority: Minor >> Fix For: 3.0RC2 >> >> >> When setting statementFetchSize property on select query with >> disjoint >> prefetches, it only uses it for the root query, while this setting >> must be >> copied to all the child prefetch queries. >> >> -- >> This message is automatically generated by JIRA. >> - >> You can reply to this email to add a comment to the issue online. >> >> > > > -- > Andrey