[jboss-user] [jBPM] - Re: JBPM 3.2.5, MSSQL 2005 - blocking in JBPM_JOB table

Sash K do-not-reply at jboss.com
Thu Sep 9 11:16:35 EDT 2010

Sash K [http://community.jboss.org/people/swishey] created the discussion

"Re: JBPM 3.2.5,MSSQL 2005 - blocking in JBPM_JOB table"

To view the discussion, visit: http://community.jboss.org/message/560920#560920

A bit more information.  Looks like the issue is with having a lot jobs that execute quickly, which results in a lot of inserts and deletes, which then results in a lot of updates to the indexes.  Having removed all the indexes in the jbpm_job table has greatly reduced blocking issues, but not eliminated them.  Is there anyway to configure jbpm not to delete jobs, but just mark them as complete?  I would rather have a cleanup script to remove completed jobs on a cycle and reduce index locking frequency.

Reply to this message by going to Community

Start a new discussion in jBPM at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100909/963a3784/attachment.html 

More information about the jboss-user mailing list