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 [http://community.jboss.org/message/560920#560920] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
