Details
-
Suggestion
-
Resolution: Fixed
-
None
Description
GH produces queries like the following when viewing the TaskBoard.jspa
JQL Query: {project = 10240} AND {fixVersion = 14978} AND ( {fixVersion is EMPTY} OR {fixVersion in unreleasedVersions(JRA)} ) AND {parent = "JRA-19051"} AND ( {status in ("1", "10005", "10033", "4", "10004")} OR {status = "3"} OR {status in ("6", "5")} ) AND {issuetype in subTaskIssueTypes()} order by cf ASC, key ASC
There are a number of potential speedups here:
- This query has lots of redundant clauses. When you specify fixVersion = 14978 you don't need the fixVersion is EMPTY OR fixVersion in unreleasedVersions(JRA) part at all.
- It is much quicker to use issues IDs as arguments to the parent clause.
- ...