Uploaded image for project: 'JIRA'
  1. JIRA
  2. JRA-19515

watchedIssues() JQL function is very slow

    Details

      Description

      On our JIRA instance, running a JQL query of "issue in watchedIssues()" takes about a minute to complete. FYI, our watchers table has 814,000 rows.

      To work around this we are still using the Voters and Watchers custom field plugin.

      1. watched_issues.patch
        13 kB
        Andreas Knecht
      2. watchedIssuesPatch.zip
        7 kB
        Andreas Knecht

        Issue Links

          Activity

          Hide
          pdzwart Pete de Zwart [Atlassian] added a comment -

          Love your work Jed.

          Show
          pdzwart Pete de Zwart [Atlassian] added a comment - Love your work Jed.
          Hide
          gbrauer1 G B added a comment -

          I just want to explicitly confirm... Is the following JQL valid with this new feature:

          watcher = currentUser()
          
          Show
          gbrauer1 G B added a comment - I just want to explicitly confirm... Is the following JQL valid with this new feature: watcher = currentUser()
          Hide
          jed Jed Wesley-Smith [Atlassian] added a comment -

          Yup, and watcher in membersof(mygroup)

          Show
          jed Jed Wesley-Smith [Atlassian] added a comment - Yup, and watcher in membersof(mygroup)
          Hide
          scott@atlassian.com Scott Farquhar [Atlassian] added a comment -

          Jed - I know that watcher = currentUser() will be fast but will the watchedIssues() function be fast also? Has that been rewritten?

          Show
          scott@atlassian.com Scott Farquhar [Atlassian] added a comment - Jed - I know that watcher = currentUser() will be fast but will the watchedIssues() function be fast also? Has that been rewritten?
          Hide
          jed Jed Wesley-Smith [Atlassian] added a comment -

          Of course, everything uses the new code. The old code hasn't been completely removed, but can be.

          Show
          jed Jed Wesley-Smith [Atlassian] added a comment - Of course, everything uses the new code. The old code hasn't been completely removed, but can be.

            People

            • Assignee:
              jed Jed Wesley-Smith [Atlassian]
              Reporter:
              gbrauer1 G B
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: