Re: Paging in web application

From: Robert Zeigler (robert..uregumption.com)
Date: Wed Apr 02 2008 - 06:07:05 EDT

  • Next message: Andrus Adamchik: "Re: Paging in web application"

    Andrus did a lot of optimizing... it was in a dev thread awhile ago.
    Don't remember the specifics offhand, sorry.

    Robert

    On Apr 2, 2008, at 4/24:59 AM , Malcolm Edgar wrote:
    > What were the big paging performance improvements in 3.0?
    >
    > regards Malcolm Edgar
    >
    > On Wed, Apr 2, 2008 at 7:27 PM, Robert Zeigler <robert..uregumption.com
    > > wrote:
    >> Typically, you're just going to use a paginated query:
    >> SelectQuery q = new SelectQuery(Artist.class);
    >> q.setPageSize(50);//triggers the pagination.
    >>
    >> You can get the size of the result set without faulting every (or
    >> any)
    >> object in it, jump to specific objects w/in the query (and only
    >> fault the
    >> "neighboring" objects on the same page), etc.
    >> This works well for most things. With the recent performances
    >> improvements
    >> in 3.0, this works wonderfully for a large portion of use cases out
    >> there.
    >> You can also use setFetchLimit to limit the # of results returned.
    >> Unfortunately, there's no corresponding "setOffset" method. But
    >> you can
    >> use SQLTemplate to accomplish the task, if you really need it.
    >>
    >> Robert
    >>
    >>
    >>
    >> On Apr 2, 2008, at 4/22:49 AM , John Emmanuel wrote:
    >>
    >>> Hi,
    >>>
    >>> Is there a best practice for paging in a web application.
    >>> If so, can somebody please direct me to a demo/article/tutorial.
    >>>
    >>> If none is available could somebody just briefly tell me how
    >>> they incorporated paging in a production webapp.
    >>>
    >>> I have read the documentation (which provides examples
    >>> of paging in desktop apps), have gone through the
    >>> petstore example (which uses ibatis PaginatedList (which btw has
    >>> now been deprecated), but am not clear about the best way
    >>> to go about it.
    >>>
    >>> regards,
    >>> John Emmanuel
    >>>
    >>
    >>



    This archive was generated by hypermail 2.0.0 : Wed Apr 02 2008 - 06:07:40 EDT