Add an index on sta_pr_participant table to improve pull request participant query performance

XMLWordPrintable

    • 1
    • 1
    • RtB - Service ops & Tech entropy

      Add a new non-clustered index on the sta_pr_participant table to optimize queries that look up pull request participants by role and user ID.

      The aim is to improve response times of the /rest/api/latest/projects/{projectKey}/repos/{repositorySlug}/participants REST endpoint for repos that have a high number of rows in the sta_pr_participant table.

       

              Assignee:
              Tom Daffurn
              Reporter:
              JP Mariano
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: