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.
