cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Logasa Bogen II <...@tamu.edu>
Subject Re: Slow Return on Paginated SelectQuery
Date Mon, 13 Apr 2009 01:43:12 GMT
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.
>   


Mime
View raw message