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

Workload report loads very slowly

    XMLWordPrintable

Details

    Description

      Summary

      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

      Notes

      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.

      Attachments

        1. Screen Shot 2018-09-28 at 5.22.07 PM.png
          112 kB
          Ruchi Tandon
        2. Screen Shot 2020-04-20 at 4.05.41 PM.png
          49 kB
          Denise Unterwurzacher [Atlassian]
        3. Screen Shot 2020-04-28 at 1.45.56 PM.png
          171 kB
          Denise Unterwurzacher [Atlassian]

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Backbone Issue Sync