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.
