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.

        Attachments

          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 added a comment -

            Yup, and watcher in membersof(mygroup)

            Show
            jed Jed Wesley-Smith 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 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 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
                Reporter:
                gbrauer1 G B
              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: