Databases
StackOverflow2013
Postsdbo
POHow to prevent NHibernate long-running process from locking up web site?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to prevent NHibernate long-running process from locking up web site?
    primarykey
    data
    text
    <p>I have an NHibernate MVC application that is using ReadCommitted Isolation.</p> <p>On the site, there is a certain process that the user could initiate, and depending on the input, may take several minutes. This is because the session is per request and is open that entire time.</p> <p>But while that runs, no other user can access the site (they can try, but their request won't go through unless the long-running thing is finished)</p> <p>What's more, I also have a need to have a console app that also performs this long running function while connecting to the same database. It is causing the same issue.</p> <p>I'm not sure what part of my setup is wrong, any feedback would be appreciated.</p> <p>NHibernate is set up with fluent configuration and StructureMap. </p> <ul> <li>Isolation level is set as ReadCommitted. </li> <li>The session factory lifecycle is HybridLifeCycle (which on the web should be Session per request, but on the win console app would be ThreadLocal)</li> </ul>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UStereško
    1. USTheFabledOne
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to prevent NHibernate long-running process from locking up web site?
      1. USTheFabledOne
      1. VTBountyStart
    2. VO
      singulars
      1. POHow to prevent NHibernate long-running process from locking up web site?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan the long running process be whittled down into small units of work in code?
      singulars
      1. POHow to prevent NHibernate long-running process from locking up web site?
      1. USRippo
    2. CO@Rippo I can modify the could to do work in smaller chunks, but I still don;t know how to handle or use the session(unitofwork). It is always all part of one giant session regardless of how my code is broken down. I can't (don't know how to) end one session/UoW and start a new one within a single process
      singulars
      1. POHow to prevent NHibernate long-running process from locking up web site?
      1. USTheFabledOne
    3. COAre you using the session-per-request pattern? I tend to use a actionfilter on my MVC controller for this pattern. This then frees me up to have mini UOW on a single actionrequest
      singulars
      1. POHow to prevent NHibernate long-running process from locking up web site?
      1. USRippo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload