ced wrote: So if I'm doing my own query then I'm going to bypass completely the hibernate layer and populating manually all the POJOs. So I'm correct the hibernate query algorithm is not efficient... or have I looked in the wrong place or lost the plot? :-) (end of quote)
You've turned on Hibernate's SQL debugging and are actually seeing 100 database hits? I assume you are talking about <many-to-one> or <one-to-one> associations, correct? Hibernate will fetch these eagerly up to a certain depth unless you have proxies enabled. However, if you enable the <b>use_outer_join</b> property this will be done using a single query. _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=1209#1209 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r=20 _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user
