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