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 maxRecords).
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.mead...@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, Alin
