Re: Slow Return on Paginated SelectQuery

From: Paul Logasa Bogen II (pl..amu.edu)
Date: Sun Apr 12 2009 - 21:43:12 EDT

  • Next message: Aristedes Maniatis: "Re: Slow Return on Paginated SelectQuery"

    So I should just bite the bullet and loop over subqueries using limit then?
    Or is there a more Cayenne way to do it?

    plb

    Kevin Menard wrote:
    > Assuming monotonically increasing PKs, you shouldn't really need to pull all
    > the PKs in. SELECT, ORDER BY, and LIMIT will serve well enough.
    >

    This archive was generated by hypermail 2.0.0 : Sun Apr 12 2009 - 21:43:45 EDT