cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <>
Subject Re: Large Results sets..
Date Tue, 23 Oct 2018 10:36:19 GMT
Hi Tony,

I think you are looking for an Iterated Query:

I'm not sure what version you are using, but it is similar in the 3.x
releases, too (change the documentation pulldown if needed).


On Mon, Oct 22, 2018 at 11:43 AM Tony Giaccone <> wrote:

> I asked this question once before, and I've looked but cant' find the
> answer.
> We're going to be using queries that would normally bring back large
> numbers of objects, 100's of thousand potentially.
> I know there's a facility in Cayenne to essentially use a "cursor" like
> fetch. But I can't remember the exact details and I wasn't able to find
> something that matched up with what I remember.
> I thought there was a query that let you bring back an Iterator, that
> returned a set of objects, not data rows, or maps, and let you iterate
> across the objects from the entire result set.
> Am I remembering correctly? Is the solution something like an iterated
> query.
> Just looking for the best possible solution.
> Tony Giaccone

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message