You were in the problem of N+1 Tuna Toksöz Eternal sunshine of the open source mind.
http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://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 -~----------~----~----~----~------~----~------~--~---
