Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-6047

Workload report loads very slowly



      The workload reports page shows list of agents, their assigned issue counts and number of breached and ongoing issues.
      To find the breached and ongoing issues we completely calculate everything to do with SLAs leading to slow performance.
      The configuration in the attached screenshot took 23 seconds to load.

      Steps to Reproduce

      1. Try to load a Workload report

      Expected Results

      Report loads in a reasonable time

      Actual Results

      Report take a very long time to load like ~30secs


      For all issues that have an assignee, we loop through all SLAs, and get goalSummaryData.
      In getting goal data, we retrieve everything about ongoing goals, including expected breach date that gets active ranges in nested loops. This is already O(n^4). It's possible that there is a worse flow.

            bfa5bb10b6a8 Arslan Qamar
            rtandon@atlassian.com Ruchi Tandon
            8 Vote for this issue
            17 Start watching this issue