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


Reply via email to