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