We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
camunda BPMProject Type: software

camunda BPM

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

Improve Task Query Performance

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.14.0, 7.14.0-alpha4
    • None
    • None
    • None

      Scope:

      • Avoid 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
      • Avoid of Standalone Tasks complexity in the task query
      • Avoid duplicate joining of ACT_RE_PROCDEF
      • Check indexes
        • Variables
        • Identity Links
        • Process Definitions

        This is the controller panel for Smart Panels app

          1.
          		 Avoid CMMN complexity in the task query if CMMN is disabled Sub-task Closed Thorben Lindhauer
          2.
          		 Avoid Standalone Tasks complexity in the task query Sub-task Closed Thorben Lindhauer
          3.
          		 Avoid duplicate joining of ACT_RE_PROCDEF in task query Sub-task Closed Thorben Lindhauer
          4.
          		 Check indexes on task table to improve task query performance Sub-task Closed Nikola Koevski

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

            Improve Task Query Performance

            XMLWordPrintable

              • Icon: Task Task
              • Resolution: Fixed
              • Icon: L3 - Default L3 - Default
              • 7.14.0, 7.14.0-alpha4
              • None
              • None
              • None

                Scope:

                • Avoid 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
                • Avoid of Standalone Tasks complexity in the task query
                • Avoid duplicate joining of ACT_RE_PROCDEF
                • Check indexes
                  • Variables
                  • Identity Links
                  • Process Definitions

                  This is the controller panel for Smart Panels app

                    1.
                    		 Avoid CMMN complexity in the task query if CMMN is disabled Sub-task Closed Thorben Lindhauer
                    2.
                    		 Avoid Standalone Tasks complexity in the task query Sub-task Closed Thorben Lindhauer
                    3.
                    		 Avoid duplicate joining of ACT_RE_PROCDEF in task query Sub-task Closed Thorben Lindhauer
                    4.
                    		 Check indexes on task table to improve task query performance Sub-task Closed Nikola Koevski

                        nikola.koevski Nikola Koevski
                        roman.smirnov Roman Smirnov
                        Votes:
                        0 Vote for this issue
                        Watchers:
                        3 Start watching this issue

                          Created:
                          Updated:
                          Resolved:

                              nikola.koevski Nikola Koevski
                              roman.smirnov Roman Smirnov
                              Votes:
                              0 Vote for this issue
                              Watchers:
                              3 Start watching this issue

                                Created:
                                Updated:
                                Resolved: