[jboss-jira] [JBoss JIRA] Created: (JBPM-931) Create indexes for foreign keys in 3.1 branch

[David Lloyd (JIRA)]

Create indexes for foreign keys in 3.1 branch
---------------------------------------------

                 Key: JBPM-931
                 URL: http://jira.jboss.com/jira/browse/JBPM-931
             Project: JBoss jBPM
          Issue Type: Bug
          Components: Core Engine
    Affects Versions: jBPM 3.1.4, jBPM 3.1.3,  jBPM 3.1.2, jBPM 3.1.1, jBPM 3.1
            Reporter: David Lloyd
         Assigned To: David Lloyd
             Fix For: jBPM 3.1.5


Many users are using jBPM 3.1.x and do not have the ability to perform a major upgrade.  However 3.1.x suffers from a significant problem in that many foreign keys do not have indexes (this problem was fixed for 3.2.0).  This causes queries against these keys to scan the full table.  In the case of database which use row locks for both reads and writes, this can lead to deadlock scenarios because many, many rows are locked unnecessarily.  Tables are frequently queried by their foreign keys; that's why they exist.  Therefore these columns should be indexed.

(Relates to JBPM-735)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira