Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-4927

Job acquisition query does not use indices

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Open
    • Priority: L3 - Default
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 7.4.x, 7.5.x
    • Component/s: engine
    • Labels:

      Description

      This report is based on experimental evidence.

      Scenario:

      • DB2 9.7
      • one process definition with an asnychronous continuation
      • one process definition with a timer event that is due far in the future
      • 20,000 instances, 5% async jobs, 95% timer jobs

      Problem: The resulting DB2 query plan shows that the acquisition query uses a full table scan and none of the indexes we provide.

      There should be an index we create by default that all databases use when making an acquisition query.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: