ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alin Popa <alin.p...@gmail.com>
Subject Re: iBatis - MySQL pagination
Date Fri, 15 May 2009 16:39:27 GMT
Thanks Larry for your quick response.

If I'm doing it in Mysql statement, I'll do it using LIMIT which is
taking exactly the same 2 params like ibatis (skipResults and

My dilemma is: why ibatis is doing this kind of abstraction if on the
underlying server is doing it wrong ? Might cause confusion and of
course, bad performances. I asked the question here, because I thought
that I'm missing something related to this pagination issue.

On Fri, May 15, 2009 at 7:15 PM, Larry Meadors <larry.meadors@gmail.com> wrote:
> Do it in the sql statement instead of using pagination in ibatis.
> Look at limit, row_count and offset here:
> http://dev.mysql.com/doc/refman/5.0/en/select.html
> You will probably need to use $substitution$ for the parameters, but
> surely some mysql stud can tell you more about that than I can. :)
> Larry

Best Regards,


View raw message