Curious how session management would apply to behavior that is exhibited by actions taken immediately upon session instantiation? This isn't some sort of downstream issue.
--ab On Tue, Apr 19, 2011 at 6:02 PM, Fabio Maulo <[email protected]> wrote: > Information technology is about 0 or 1; "I believe" is neither 0 nor 1. > Before do any kind of supposition about what is happening you have to know > which is the session management pattern you are using. > After that we can continue the discussion about optimizations. > > > On Tue, Apr 19, 2011 at 7:56 PM, Andrew Badera <[email protected]> wrote: > >> I believe the session is maintained, I haven't seen it being explicitly >> closed. Then again, I just got on this project late last week, and there's >> some potential I might be missing it. 98% confident it remains open however. >> >> --ab >> >> >> On Tue, Apr 19, 2011 at 5:48 PM, Fabio Maulo <[email protected]>wrote: >> >>> 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. >>> >> >> -- >> 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.
