Yes, this is the most compelling case; ie. a 1 - to - few relationship. However, I would be interested to see actual timings showing that the single enormous ResultSet is actually quicker than the 3000 + 1 seperate selects. I'm not saying for sure that it isn't in your case, but whenever I have done *actual* tests of this, I have always found it to be *slower* on real databases (when on the same machine, of course).
Remember that your HUGE ResultSet contains *much* more data (the data in the outer collection is now 10 x as much, because of repetition. Philipp Meier <[EMAIL PROTECTED]> To: hibernate list <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Hibernate] Performance of "nested relations" eforge.net 19/02/03 08:11 PM On Wed, Feb 19, 2003 at 10:01:26AM +1100, [EMAIL PROTECTED] wrote: > > Currently there is no way to grab contained collections in a single select > (and I have extreme doubts that it would be a performance increase unless > access to the database is over a slow network). A much better approach in > most cases is to make the Map lazy. In my case the outer collection containts 3000+ elements which itself contain ~10 elements in the map. IMHO it's a difference to make 3000 queries or not. Even when - like in my case - the database is not accessed over a network. Making the map lazy is possible, though. -billy. -- Meisterbohne Söflinger Straße 100 Tel: +49-731-399 499-0 eLösungen 89077 Ulm Fax: +49-731-399 499-9 ------------------------------------------------------- This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. The most comprehensive and flexible code editor you can use. Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. www.slickedit.com/sourceforge _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel ********************************************************************** Any personal or sensitive information contained in this email and attachments must be handled in accordance with the Victorian Information Privacy Act 2000, the Health Records Act 2001 or the Privacy Act 1988 (Commonwealth), as applicable. This email, including all attachments, is confidential. If you are not the intended recipient, you must not disclose, distribute, copy or use the information contained in this email or attachments. Any confidentiality or privilege is not waived or lost because this email has been sent to you in error. If you have received it in error, please let us know by reply email, delete it from your system and destroy any copies. ********************************************************************** ------------------------------------------------------- This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. The most comprehensive and flexible code editor you can use. Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. www.slickedit.com/sourceforge _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel