uggestions?
>
> Thanks.
>
>
> -Original Message-
> From: Larry Meadors [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 01, 2005 11:37 AM
> To: user-java@ibatis.apache.org
> Subject: Re: Stored procedure with queryForList skipresults and
> maxresults
&g
, August 01, 2005 11:37 AMTo:
user-java@ibatis.apache.orgSubject: Re: Stored procedure with
queryForList skipresults and maxresults
It is.When you use skip/max, the
trimming is done after the results are retrieved. If you are looking to
improve performance, it would be better to do it in the
Larry
Meadors
To: user-java@ibatis.apache.org
Sent: Monday, August 01, 2005 8:37
AM
Subject: Re: Stored procedure with
queryForList skipresults and maxresults
It is.When you use skip/max, the trimming is done after
the results are retrieved. If you are looking to
It is.
When you use skip/max, the trimming is done after the results are
retrieved. If you are looking to improve performance, it would be
better to do it in the stored procedure.
Larry
On 8/1/05, Rao, Satish <[EMAIL PROTECTED]> wrote:
I am using a queryForList with
skipresults and maxr
Title: Stored procedure with queryForList skipresults and maxresults
I am using a queryForList with skipresults and maxresults to retrieve records from Oracle. I have implemented this using and SQL statement. I am not explicitly passing in skipresults and maxresults to the SQL as ibatis