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

History queries with authorization checks are slow

XMLWordPrintable

      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.

        This is the controller panel for Smart Panels app

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

            [CAM-6839] History queries with authorization checks are slow

            Thorben Lindhauer created issue -
            Thorben Lindhauer made changes -
            Affects Version/s New: 7.5.4 [ 14606 ]
            Thorben Lindhauer made changes -
            Link New: This issue is depended on by SUPPORT-2707 [ SUPPORT-2707 ]
            Thorben Lindhauer made changes -
            Link New: This issue is related to CAM-6462 [ CAM-6462 ]

            Daniel Meyer added a comment -

            christopher.zell We can have a quick chat about this on tuesday: basically it would mean that we use the join based authorization check for history as well

            Daniel Meyer added a comment - christopher.zell We can have a quick chat about this on tuesday: basically it would mean that we use the join based authorization check for history as well
            Christopher Kujawa made changes -
            Rank New: Ranked higher
            Christopher Kujawa made changes -
            Rank New: Ranked higher
            Michael Schoettes made changes -
            Link New: This issue is depended on by SUPPORT-2520 [ SUPPORT-2520 ]
            Daniel Meyer made changes -
            Remote Link New: This issue links to "Page (camunda confluence)" [ 11217 ]
            Daniel Meyer made changes -
            Assignee Original: Christopher Kujawa [ christopher.zell ] New: Johannes [ johannes.heinemann ]

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

                Created:
                Updated:
                Resolved: