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

Evaluate if ACT_HI_ACTINST.PROC_DEF_KEY index speeds up history queries with authorization

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.6.0, 7.6.0-alpha4
    • None
    • engine
    • None

      History queries select a distinct set of process definition keys before joining the authorization table. We have evidence that an index on the process definition key column improves performance on 7.4 (with ~5 million historic activity instances). Let's check whether this also improves performance for the reworked history queries on the master branch.

        This is the controller panel for Smart Panels app

              sebastian.menski Sebastian Menski
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: