cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <blackn...@gmail.com>
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:

https://cayenne.apache.org/docs/4.0/cayenne-guide/#performance-tuning

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).

mrg


On Mon, Oct 22, 2018 at 11:43 AM Tony Giaccone <tony@giaccone.org> 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
>

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