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
