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

        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