yeah, i'm not sure that's going to help: http://j.otdown.com/15Jul09/5397zi/6e1
On Wed, Jul 15, 2009 at 10:45 AM, Tuna Toksoz <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
