Re: Duplicates when trying to avoid N+1 selects

2008-07-11 Thread mailjoe
ad or answer you, just that I think > if you can make this a more concrete example, instead of a tuple > calculus exercise, then you might get more (and better) responses. > > Larry > > > On Fri, Jul 11, 2008 at 8:02 AM, mailjoe <[EMAIL PROTECTED]> wrote: >> &

Duplicates when trying to avoid N+1 selects

2008-07-11 Thread mailjoe
Hi, We have a ComplexObject made of one instance of aGroup and one instance of bGroup. The aGroup is made of a collection of A instances. The bGroup is made of a colleciton of B instances. We have one SQL Map for aGroup, and another one for bGroup. If aGroup contains m A's and bGroup contains n