It's important to bare in mind most design decisions were made for a reason. There's rarely any blanket rule for speeding up your queries, no magic switch; if there were such a thing, surely it would be the default? You may be interested in Ayende's NHProf <http://nhprof.com/>, which can be used to analyse your application for possible optimisations.
On Tue, Apr 7, 2009 at 6:12 PM, Arman <[email protected]> wrote: > > i read somewhere that if you set "use_outerjoin" config in settings to > "true" , your performance would be better , is it correct ? > > > On Apr 7, 7:17 pm, Tuna Toksoz <[email protected]> wrote: > > You were in the problem of N+1 > > > > Tuna Toksöz > > Eternal sunshine of the open source mind. > > > > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > > > On Tue, Apr 7, 2009 at 7:15 PM, General <[email protected]> wrote: > > > > > Hello, > > > > > I've had recently a big problem with retrieving rows from my database. > > > Using CreateCriteria I had to wait about 12s to get 1700 rows. I > > > didn't know where is the problem. > > > > > After 2 hours I looked in NHibernate documentation again and I saw > > > this: > > > > > ****************** > > > <many-to-one > > > [...] > > > fetch="join|select" (5) > > > [...] > > > /> > > > > > (5) fetch (optional - defaults to select): > > > ****************** > > > > > Hmm "defaults to select" ?! In my opinion it's strange, that default > > > value of fetch in many-to-one is 'select'. Never mind. So let's back > > > to our performance. I added to my many-to-one associations in mappings > > > files: fetch="join". > > > > > What was the effect? From 15s I have 2s. > > > > > Maybe this would help someone. > > > Chris. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
