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

Improve performance of historic variable instance query

    Details

      Description

      TODO:

      • investigate to improve the performance of the historic variable instance query
        historyService.createHistoricVariableInstanceQuery().processInstanceIdIn(processInstanceIds).variableName(variableName).list();
      • with activated authorization
      • apply "new" authorization check like it is already done in historic process instance query

      Hint:

      • the query
        SELECT DISTINCT DKEYS.PROC_DEF_KEY_ FROM ACT_HI_VARINST DKEYS;

        seems to be slow (see the support issue for details)

      • the "old" authorization check is still used in the historic variable query

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            roman.smirnov Smirnov Roman
            Reporter:
            philipp.ossler Philipp Ossler
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: