Paged Queries Implemented

From: Andrus (andru..bjectstyle.org)
Date: Wed Sep 18 2002 - 01:42:26 EDT

  • Next message: Andrus: "Re: Paged Queries Implemented"

    A little announcement - a feature needed long time ago finally has been
    implemented.

    I am talking about the ability to do on-demand object list pagination
    (resolving objects one page at a time) for big queries. I just checked in
    the first working implementation. Using it is as easy as doing:

    query.setPageSize(60);

    Everything else is transparent and is handled by Cayenne. More details in
    CVS version of User Guide, section 5.8.4. One thing to mention -
    preliminary test results show 5x - 7x speed increase when fetching a
    relatively large result set (2000 objects).

    Enjoy.

    Andrus

    P.S. code may actually need some refactoring, since it was mostly written
    after midnight and may look a bit crazy :-)



    This archive was generated by hypermail 2.0.0 : Wed Sep 18 2002 - 01:42:04 EDT