you can continue with your game or answer my questions. On Tue, Apr 19, 2011 at 8:05 PM, Andrew Badera <[email protected]> wrote:
> 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. > -- 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.
