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.
