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