Search code examples
sql-serverwinformsnhibernatecastle-activerecordsession-scope

NHibernate WinForms Multiple (SessionScope) Sleeping Sessions performance


I've implemented NHibernate Session per Form aproach with Castle AR (SessionScope), if i open a form, i open a (SessionScope) session and Disposes it at form close. If i open N single forms i have N db opened sleepy sessions as long as the form is opened, the question is: Sleepy sessions implies performance issues? is it wrong to have N opened sleepy sessions on db?.


Solution

  • lightweight see

    Update:

    I dont think that this will imply performance problem, maybe the servers maximum acctepted connections will be reached, but only if all sleeping sessions will perform something from time to time, otherwise thay will surely timeout.