Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-11277 Improve Task Query Performance
  3. CAM-12410

Avoid duplicate joining of ACT_RE_PROCDEF in task query

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.0, 7.14.0-alpha4
    • None
    • engine
    • None

      When a process definition filter is used and the authorization check is active, then the process definition table is joined twice. This can be consolidate into one join.

      Which join type to use (left join, inner join)?

      • If cmmn and standalone tasks are disabled,
        • inner join (since every remaining task must belong to a process definition)
      • Else
        • If it is an or query
          • left join
        • If it is an and query
          • If authorization is enabled
            • left join (to not lose cmmn tasks for which we do not enforce permissions)
          • If authorization is disabled
            • inner join

        This is the controller panel for Smart Panels app

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

                Created:
                Updated:
                Resolved: