sounds like you need to be using result iterator.
See: http://cayenne.apache.org/doc/api/org/apache/cayenne/access/ResultIterator.html
Robert
On Apr 12, 2009, at 4/127:42 PM , Paul Logasa Bogen II wrote:
> I have a table with ~683k entries in it. I have a maintenance task
> that requires me to hit every entry. Since I know the results are
> much too big to return all at once, I've set the page size to 50.
> However, Cayenne appears to be attempting the full query first
> before falling back to paging. This is taking nearly half an hour
> for it to fall back, at which point everything works flawlessly. Is
> there a way to force the query to be paginated or to reduce the
> timeout on a query?
>
> plb
This archive was generated by hypermail 2.0.0 : Sun Apr 12 2009 - 21:05:39 EDT