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

History queries with authorization checks are slow

    XMLWordPrintable

    Details

      Description

      Investigate performance of authorization checks for history queries on Oracle and evaluate improvements. Use https://github.com/camunda/camunda-bpm-platform/blob/master/qa/performance-tests-engine/src/test/java/org/camunda/bpm/qa/performance/engine/query/HistoryAuthorizationQueryPerformanceTest.java as a starting point.

        Attachments

        1. HistroyProcessInstanceAuthorizationCheck_SQL_Query.sql
          5 kB
        2. Db2-97_002.png
          Db2-97_002.png
          227 kB
        3. Db2-97_001.png
          Db2-97_001.png
          225 kB
        4. Db2-105_003.png
          Db2-105_003.png
          189 kB
        5. Db2-105_002.png
          Db2-105_002.png
          187 kB
        6. Db2-105_001.png
          Db2-105_001.png
          189 kB

          Issue Links

            Activity

              People

              Assignee:
              roman.smirnov Roman Smirnov
              Reporter:
              thorben.lindhauer Thorben Lindhauer
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: