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

GH is producting inefficient queries when viewing the TaskBoard

    XMLWordPrintable

Details

    • 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

      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:

      1. 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.
      2. It is much quicker to use issues IDs as arguments to the parent clause.
      3. ...

      Attachments

        Activity

          People

            Unassigned Unassigned
            bbain bain
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: