Wait... what would those options be? I already had hql eager fetching everything and performance wasn't sufficient. I'm unaware of any other option except to use sql in my hbm or c-sharp.
On Wed, Jul 15, 2009 at 9:07 AM, Fabio Maulo <[email protected]> wrote: > 2009/7/15 Leonard Smith <[email protected]> > >> I have an object with a really deep hierarchy. Retrieving this object >> happens on every page of my application. Some elements I need to display >> are four or five levels deep. >> >> It was only recently that performance of this query started to >> nose-dive... not that it was wonderful before, but tolerable. >> >> So, since I can't use return-join and load-collection in sprocs, is my >> only choice to get performant sql really throwing in a few hundreds of lines >> of sql in my mapping file or c-sharp? > > > few info to advise you a way... but in general you have other 2 or 3 > options using NH. > > -- > Fabio Maulo > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
