Skip to content
Snippets Groups Projects

Add project ID index to `project_authorizations` table to optimize queries

Merged Stan Hu requested to merge sh-add-project-id-index-project-authorizations into master

As described in #27443 (closed), the project_authorizations table is often used to retrieve all team members of this project. This can lead to a number of slow queries impacting load times. This MR adds an index for just project_id.

Closes #27443 (closed)

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
Please register or sign in to reply
Loading