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