On Jan 16, 2008, at 11:51 AM, Daniel Kvasnička jr. wrote:
What troubles me now is that paginated query still retrieves
EVERYTHING :(
The manual says Cayenne will retrieve only PKs, but the code I posted
before results in:
Actually it still does the right thing - it fetches all objects, but
reads only ids of objects from the ResultSet beyond page 1.
BTW, this is optimized further in 3.0 to read just ids (and do not
resolve page 1 immediately), but 2.0.x implementation also provides a
significant performance gain compared to non-paginated queries.
Andrus