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.

        Issue Links

          Activity

          Hide
          pdzwart Pete de Zwart added a comment -

          Love your work Jed.

          Show
          pdzwart Pete de Zwart 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: