Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.132.250 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=JWKyoxWUW1m2ZIxs+eCNqsPxAnjSqXENBazbideJiNnNdmstIlobOlRs1vbeTYzQmibvZdc6lFpUSmPr4QJj1Y31RhpBQkjwO+jSJ0lKSRrYLg6bfMGuEKWgZYfcxni0119RAMFNHBjUZ3bNOIRDSZjb+3JV22SlqTpHQgV7das=
Message-ID: <16178eb10705111340g5b808e40r5d94cd48f2e1a9ad@mail.gmail.com>
Date: Fri, 11 May 2007 14:40:04 -0600
From: "Clinton Begin" <clinton.begin@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: QueryForList : How does maxRows work?
In-Reply-To: <16178eb10705111338g747cf7a5rf3667365603afa44@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_141168_29877191.1178916004317"
References: <10415657.post@talk.nabble.com>
	 <16178eb10705100948m3071b52ej839130fe8ee595fe@mail.gmail.com>
	 <10417487.post@talk.nabble.com>
	 <16178eb10705111338g747cf7a5rf3667365603afa44@mail.gmail.com>

------=_Part_141168_29877191.1178916004317
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

PS:  if it hasn't been made clear by my previous posts, if you call
queryForList with a maxRows attribute, it will only request that many rows
back from the database.  It won't bring back all 10k.  This of course
depends on the driver, but I've never seen one that does something that
silly.  ;-)

Clinton

On 5/11/07, Clinton Begin <clinton.begin@gmail.com> wrote:
>
> If it's a proc returning that result set, then I doubt setMaxRows would
> help anyway.  You can't just apply a limit outside of the scope of the proc,
> the result set has already been built.
>
> The only applicable performance factor that you have control of outside of
> the proc is the fetch size, the size of the batches of rows that are
> returned at a time.  And even that is only a driver "hint".  iBATIS supports
> it as an attribute of the <select> element.
>
> Clinton
>
> On 5/10/07, BenBaril <benjamin.baril@fbn.ca> wrote:
> >
> >
> > I'm working with a small team doing a Proof of Concept at a customer
> > location. We're looking at iBATIS as a DAO solution however we have many
> > stored procedures that return upwards of 10k rows. Our previous solution
> > cut
> > the number of rows returned to a fixed limit.
> >
> > Is there any way to do this using iBATIS currently? Since we have no
> > handle
> > to the statement, I'm at a loss right now.
> >
> > Any help would be greatly appreciated.
> >
> > Thanks
> >
> > Clinton Begin wrote:
> > >
> > > No, it doesn't call setMaxRows.  Probably a legacy decision for driver
> > > compatibility reasons, but I suppose we're well past that now.  If you
> > > think
> > > it will improve performance for you, we can probably add it.  If so,
> > > please
> > > open a JIRA ticket for it.
> > >
> > > Clinton
> > >
> > > On 5/10/07, BenBaril < benjamin.baril@fbn.ca> wrote:
> > >>
> > >>
> > >> I'm wondering on how the implementation of maxRows works when calling
> > >> queryForList. Does it execute a stmt.setMaxRows(maxRows); or does it
> > >> receive
> > >> all the rows from the database, parse then trim?
> > >>
> > >> Thanks,
> > >> Benjamin Baril
> > >> --
> > >> View this message in context:
> > >>
> > http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10415657
> > >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com
> > .
> > >>
> > >>
> > >
> > >
> >
> > --
> > View this message in context: http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10417487
> >
> > Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> >
> >
>

------=_Part_141168_29877191.1178916004317
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

PS:&nbsp; if it hasn&#39;t been made clear by my previous posts, if you call queryForList with a maxRows attribute, it will only request that many rows back from the database.&nbsp; It won&#39;t bring back all 10k.&nbsp; This of course depends on the driver, but I&#39;ve never seen one that does something that silly.&nbsp; ;-)
<br><br>Clinton<br><br><div><span class="gmail_quote">On 5/11/07, <b class="gmail_sendername">Clinton Begin</b> &lt;<a href="mailto:clinton.begin@gmail.com">clinton.begin@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
If it&#39;s a proc returning that result set, then I doubt setMaxRows would help anyway.&nbsp; You can&#39;t just apply a limit outside of the scope of the proc, the result set has already been built.&nbsp; <br><br>The only applicable performance factor that you have control of outside of the proc is the fetch size, the size of the batches of rows that are returned at a time.&nbsp; And even that is only a driver &quot;hint&quot;.&nbsp; iBATIS supports it as an attribute of the &lt;select&gt; element.
<div><span class="e" id="q_1127cdcfc9c4a13f_1"><br><br>Clinton<br><br><div><span class="gmail_quote">On 5/10/07, <b class="gmail_sendername">BenBaril</b> &lt;<a href="mailto:benjamin.baril@fbn.ca" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
benjamin.baril@fbn.ca</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>I&#39;m working with a small team doing a Proof of Concept at a customer<br>location. We&#39;re looking at iBATIS as a DAO solution however we have many<br>stored procedures that return upwards of 10k rows. Our previous solution cut
<br>the number of rows returned to a fixed limit.<br><br>Is there any way to do this using iBATIS currently? Since we have no handle<br>to the statement, I&#39;m at a loss right now.<br><br>Any help would be greatly appreciated.
<br><br>Thanks<br><br>Clinton Begin wrote:<br>&gt;<br>&gt; No, it doesn&#39;t call setMaxRows.&nbsp;&nbsp;Probably a legacy decision for driver<br>&gt; compatibility reasons, but I suppose we&#39;re well past that now.&nbsp;&nbsp;If you<br>
&gt; think
<br>&gt; it will improve performance for you, we can probably add it.&nbsp;&nbsp;If so,<br>&gt; please<br>&gt; open a JIRA ticket for it.<br>&gt;<br>&gt; Clinton<br>&gt;<br>&gt; On 5/10/07, BenBaril &lt;<a href="mailto:benjamin.baril@fbn.ca" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

benjamin.baril@fbn.ca</a>&gt; wrote:<br>&gt;&gt;<br>&gt;&gt;<br>&gt;&gt; I&#39;m wondering on how the implementation of maxRows works when calling<br>&gt;&gt; queryForList. Does it execute a stmt.setMaxRows(maxRows); or does it
<br>&gt;&gt; receive<br>&gt;&gt; all the rows from the database, parse then trim?<br>&gt;&gt;<br>&gt;&gt; Thanks,<br>&gt;&gt; Benjamin Baril<br>&gt;&gt; --<br>&gt;&gt; View this message in context:<br>&gt;&gt; <a href="http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10415657" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10415657</a><br>&gt;&gt; Sent from the iBATIS - User - Java mailing list archive at <a href="http://Nabble.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Nabble.com</a>.<br>&gt;&gt;<br>
&gt;&gt;<br>&gt;<br>&gt;<br><br>--<br>View this message in context: <a href="http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10417487" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.nabble.com/QueryForList-%3A-How-does-maxRows-work--tf3722314.html#a10417487
</a><br>Sent from the iBATIS - User - Java mailing list archive at <a href="http://Nabble.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Nabble.com</a>.<br><br></blockquote></div><br>
</span></div></blockquote></div><br>

------=_Part_141168_29877191.1178916004317--