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 maxresults to retrieve records from Oracle. I have implemented this using <select> and SQL statement. I am not explicitly passing in skipresults and maxresults to the SQL as ibatis takes care of this. It works great.
Now I want to use a stored procedure instead of a SQL. I am assuming even for the stored procedure I don't need to pass in skipresults and maxresults to the stored procedure. Please confirm if my assumption is correct.
Thanks
