Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-931

Create indexes for foreign keys in 3.1 branch

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • None
    • jBPM 3.1.0, jBPM 3.1.1, jBPM 3.1.2, jBPM 3.1.3, jBPM 3.1.4
    • Runtime Engine
    • None
    • Workaround Exists
    • Hide

      Currently customers may manually add indexes for the foreign keys that cause contention, if they have DBAs of appropriate skill level to identify problem columns.

      Show
      Currently customers may manually add indexes for the foreign keys that cause contention, if they have DBAs of appropriate skill level to identify problem columns.

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

              tom.baeyens Tom Baeyens (Inactive)
              dlloyd@redhat.com David Lloyd
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: