RE: Stored procedure with queryForList skipresults and maxresults

2005-08-03 Thread Prashanth Sukumaran
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

RE: Stored procedure with queryForList skipresults and maxresults

2005-08-03 Thread Rao, Satish
, 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

Re: Stored procedure with queryForList skipresults and maxresults

2005-08-02 Thread Darek Dober
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

Re: Stored procedure with queryForList skipresults and maxresults

2005-08-01 Thread Larry Meadors
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

Stored procedure with queryForList skipresults and maxresults

2005-08-01 Thread Rao, Satish
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