we would better help if you show some code and mapping, and maybe the sql output of your inefficient query.
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Wed, Jul 15, 2009 at 5:43 PM, Leonard Smith <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
