you should know that FetchMode.Eager is exactly like Join you could use Select and just access the associations after the load and it will load them (multiple round trips) you could set fetch mode to sub select - this is good when you load multiple objects and wanna batch load their associations loads to one query but unfortunately, this can only be done from the mappings and will affect all queries on the entity
Or you could use the multi criteria... but its much less comfortable,. If you fetch only one entity and need to load all of its association, then i thinks you should check first how much time is added by a round trip. if the your app server has good connectivity to the DB, a round trip (no extra IOs, just the round trip) might be very fast, and the performance might only be slightly improved by using multy criteria, and you might decide to go with the simpler and only slightly slower solution On Thu, Apr 8, 2010 at 9:32 PM, Ramon Smits <[email protected]> wrote: > > It seems that I need to build a Multi Criteria Query. Will look into > that first. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
