Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-20222

Improve the way the Active Sprint is loaded for better performance and/or rendering of items

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • Sprint
    • 1
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Problem Definition

      Active Sprints can load slower than the Backlog.
      Example, clicking on the "Quick Filter" will reload the entire Active Sprints data. This can take longer for a complex Sprint with lots of issues.

      We have improved how Backlog is loaded in JSWSERVER-9920

      Suggested Solution

      • Reduce the number of JQL queries needed to run
      • Load only the necessary data (minus the Epic and Version data)
      Notes

      In 8.3.0, click on "Quick filter" action show

      With com.atlassian.jira.issue.search.providers DEBUG

      • Backlog 
        2019-08-27 13:15:24,864 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND ( {cf[10106] in openSprints()} OR NOT {status in ("10001")} ) AND {issuetype != "10000"} AND {issuetype in standardIssueTypes()} AND {assignee = currentUser()} AND {issuetype in standardIssueTypes()} order by Rank ASC
2019-08-27 13:15:24,866 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+(+(+projid:10000 +(status:10001 status:3 status:10000)) +(+((customfield_10106:1) (#nonemptyfieldids:status -status:10001 #visiblefieldids:status)) +(#nonemptyfieldids:type -type:10000 #visiblefieldids:type))) +(type:10002 type:10004 type:10000 type:10001)) +issue_assignee:admin +(type:10002 type:10004 type:10000 type:10001)
2019-08-27 13:15:24,873 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND ( {cf[10106] in openSprints()} OR NOT {status in ("10001")} ) AND {issuetype != "10000"} AND {issuetype in standardIssueTypes()} order by Rank ASC
2019-08-27 13:15:24,873 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+(+projid:10000 +(status:10001 status:3 status:10000)) +(+((customfield_10106:1) (#nonemptyfieldids:status -status:10001 #visiblefieldids:status)) +(#nonemptyfieldids:type -type:10000 #visiblefieldids:type))) +(type:10002 type:10004 type:10000 type:10001)
2019-08-27 13:15:24,875 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"customfield_10101": com.atlassian.jira.issue.search.parameters.lucene.sort.MappedSortComparator@d6f083dd>]
      • Active Sprints 
        2019-08-27 13:14:14,787 http-nio-8830-exec-22 DEBUG admin 794x507x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND {cf[10106] in openSprints()}
2019-08-27 13:14:14,788 http-nio-8830-exec-22 DEBUG admin 794x507x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+projid:10000 +(status:10001 status:3 status:10000)) +(customfield_10106:1)
2019-08-27 13:14:15,865 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND {cf[10106] in openSprints()}
2019-08-27 13:14:15,865 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+projid:10000 +(status:10001 status:3 status:10000)) +(customfield_10106:1)
2019-08-27 13:14:15,874 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND {cf[10106] in openSprints()} AND {assignee = currentUser()} order by Rank ASC
2019-08-27 13:14:15,874 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+(+projid:10000 +(status:10001 status:3 status:10000)) +(customfield_10106:1)) +issue_assignee:admin
2019-08-27 13:14:15,875 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL sorts: [<custom:"customfield_10101": com.atlassian.jira.issue.search.parameters.lucene.sort.MappedSortComparator@d6f083dd>]
2019-08-27 13:14:15,880 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND {cf[10106] in openSprints()}
2019-08-27 13:14:15,880 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+projid:10000 +(status:10001 status:3 status:10000)) +(customfield_10106:1)
2019-08-27 13:14:15,881 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {status in ("10001", "3", "10000")} AND {cf[10106] in openSprints()} order by Rank ASC
2019-08-27 13:14:15,881 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +(+projid:10000 +(status:10001 status:3 status:10000)) +(customfield_10106:1)
2019-08-27 13:14:15,886 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL query: {project = "STP"} AND {issuetype = "Epic"} order by Rank ASC
2019-08-27 13:14:15,886 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [c.a.j.i.search.providers.LuceneSearchProvider] JQL lucene query: +projid:10000 +type:10000

      With com.atlassian.greenhopper.performance DEBUG

      • Backlog 
        2019-08-27 13:15:24,877 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [com.atlassian.greenhopper.performance] SearchProvider.searchAndSort  6ms
2019-08-27 13:15:24,877 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [com.atlassian.greenhopper.performance] collectIssues (search and callback)   8ms
2019-08-27 13:15:24,877 http-nio-8830-exec-5 DEBUG admin 795x531x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/plan/backlog/data.json [com.atlassian.greenhopper.performance] collectIssues (callback only) 2ms
      • Active Sprints 
        2019-08-27 13:14:15,878 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] SearchProvider.searchAndSort  6ms
2019-08-27 13:14:15,878 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] collectIssues (search and callback)   10ms
2019-08-27 13:14:15,878 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] collectIssues (callback only) 2ms
2019-08-27 13:14:15,881 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] SearchProvider.search  2ms
2019-08-27 13:14:15,881 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] ParentSwimlanesDataCallback   2ms
2019-08-27 13:14:15,883 http-nio-8830-exec-7 DEBUG admin 794x508x1 1vurvhf 0:0:0:0:0:0:0:1 /rest/greenhopper/1.0/xboard/work/allData.json [com.atlassian.greenhopper.performance] SearchProvider.search  2ms

      Attachments

        Activity

          People

            Unassigned Unassigned
            znoorsazali Zul NS [Atlassian]
            Votes:
            3 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: