ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashok Madhavan" <ashok.madha...@gmail.com>
Subject Re: Pagination
Date Tue, 03 Jul 2007 05:18:12 GMT
Hi Larry,

I our project for pagination, we use sql. we do the nested select within a
select within a select.

Is there a better way to do it in general and in iBatis.

regards
Ashok

On 7/2/07, Larry Meadors <lmeadors@apache.org> wrote:
>
> ..unless you can do it in the SQL instead. :)
>
> Some drivers want to bring back all the data before processing it, so
> it can cost you dearly to do this in the Java side.
>
> Larry
>
>
> On 7/2/07, Clinton Begin <clinton.begin@gmail.com> wrote:
> > Right.  Don't use the paginator stuff...but feel free to still use the
> > query limits:
> >
> > queryForList("statement", param, offset, maxrows)
> >
> > clinton
> >
> > On 7/1/07, Larry Meadors <lmeadors@apache.org> wrote:
> > > The best example is one that doesn't exist: don't use it. :)
> > >
> > > It's not going to be in iBATIS 3 because it's not really part of the
> > > core of what iBATIS does - mapping data.
> > >
> > > Most all modern databases provide similar functionality that will
> > > perform better, and use fewer resources.
> > >
> > > Larry
> > >
> > >
> > > On 7/1/07, André Rodrigues Pena <andre.ufrj@gmail.com> wrote:
> > > > Hi all,
> > > > I'm new to iBatis. I'd like to see a complete example of how to use
> > > > pagination in my queries. I searched google but I didn't find an
> example
> > > > including both query and java example of usage.
> > > >
> > > > Thanks in advance
> > > >
> > > > --
> > > > André Rodrigues Pena
> > >
> >
>

Mime
View raw message