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

Improve Task Query Performance

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open
    • Priority: L3 - Default
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      Proposals:

      • Get rid of CMMN complexity in the task query (if CMMN is disabled)
        • LEFT JOIN ACT_RE_PROCDEF → INNER JOIN ACT_RE_PROCDEF
        • LEFT JOIN ... ACT_RU_AUTHORIZATION → INNER JOIN ... ACT_RU_AUTHORIZATION
        • Remove CASE_EXECUTION_ID_ IS NULL check
      • Get rid of Standalone Tasks complexity in the task query
      • Avoid duplicate joining of ACT_RE_PROCDEF
      • If the authenticated user is admin or member of an admin group, then no authorization checks are necessary.
      • Check subselects in FROM part → at least on MySQL 5.7 they might be expensive (MySQL 5.7 rewrites such queries)
      • Check indexes:
        • Variables
        • Identity Links
        • Process Definitions

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              roman.smirnov Smirnov Roman
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated: