alright !!! So, may be we can work on it this weekend... I was planning on rewriting RelationCollection + making some changes to SQL query generation for lazy collection. But I must confess I have to spend some...Please let me know how you want to go about doing this. I am willing to put in this weekend plus more time next week.
cheers -----Original Message----- From: Patric Bechtel [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 12:41 AM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] Lazy Collection: Why join so early? [Viruschecked] On Wed, 10 Jul 2002 12:18:56 -0700, Sudhir Bhojwani wrote: IMHO this first implementation is just a bit "rough", and far from optimal. I do not see why it can't be done the way you suggest it; what about contributing that functionality? I would help a bit, too :-) >Hello, > >e.g. Department has many Employees defined as Lazy Collection. > >When executing the OQL "select p from com.sample.Department p", why does >the generated SQL have a join with Employee table. Why can't this be done >later when the user tries to access the Employees from Department. I see >that >RelationCollection maintains the IDs and loads the actual Employee object >on demand. However, loading of these IDs require a join, which is obviously >expensive. I thought it would be better if even the IDs were loaded later on >demand. This is very helpful in real enterprise applications, where objects >end >up having a network of relations, and trying to load the unwanted IDs could >be expensive. > >cheers >sudhir bhojwani >http://www.altoweb.com > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > > sincerely, Patric Bechtel IPCON Informationssysteme ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
