Again: you got 4k instances, then what you are doing with that NH's session ?
Possible response: 1) the session is maintained opened to update some of those entities, upload relations and then commit 2) the session is closed immediately On Tue, Apr 19, 2011 at 7:43 PM, Andrew Badera <[email protected]> wrote: > In this particular case, it's pretty much a pure data service, returning > our product catalog to various internal and partner consumers, sometimes > through another layer or two of abstraction. > > Hadn't looked into nor given any real thought to session management. > Working on adding distributed caching, so hoping to have clients with edit > rights push updates to cache at the same time as DB, and minimize DB hits > over the lifetime of the service processes across the farm. > > --ab > > > > On Tue, Apr 19, 2011 at 5:40 PM, Fabio Maulo <[email protected]> wrote: > >> Nice exercise. >> What you do after have those 4K instances ? >> Are you changing some data ? >> I mean: you got 4k instances, then what you are doing with that NH's >> session ? >> >> On Tue, Apr 19, 2011 at 4:53 PM, Andrew Badera <[email protected]> wrote: >> >>> Hello- >>> >>> It seems that nHibernate 3.1 performance around an EAV schema is very >>> poor. Dealing with 4000 primary objects with 60 different attribute types: a >>> total of 140,000 object-attribute rows in the database. So, to fully hydrate >>> the 4000 primary objects, there are multiple sets of 140,000 calls being >>> made in .NET to initialize and populate the collections of attributes. This >>> process takes 20+ seconds, which is wholly unnacceptable for a 4000 item >>> resultset. Join and Eager fetch plans do not help. It is not an N+1 issue as >>> far as I can tell -- only 3 queries are being made against the DB. >>> >>> I posted this here the other day, but have not been able to find a >>> solution; is there no feasible solution with nHibernate, or any ORM for that >>> matter? >>> >>> >>> http://stackoverflow.com/questions/5682668/how-to-resolve-poor-nhibernate-collection-initialization/ >>> >>> Thanks for any help, I'd rather not have to throw nHibernate out here- >>> ∞ Andy Badera >>> ∞ +1 518-641-1280 Google Voice >>> ∞ This email is: [ ] bloggable [x] ask first [ ] private >>> ∞ Google me: http://www.google.com/search?q=andrew%20badera >>> >>> >>> -- >>> 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. >>> >> >> >> >> -- >> 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. >> > > -- > 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. > -- 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.
