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

Improve performance of historic process instance query by process definition ID

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • L3 - Default
    • None
    • None
    • engine

    Description

      Scenario:

      For large volumes of historical data, the historic process instance query by process definition ID can involve full table scans and therefore perform badly. The performance should be improved, because this is the default search query when accessing the process definition history view in Cockpit.

      Hints:

      An index on the column ACT_HI_PROCINST.PROC_DEF_ID_ seems to improve the performance (see linked support issue).

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

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

              Dates

                Created:
                Updated:

                Salesforce