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 -~----------~----~----~----~------~----~------~--~---
