Significantly reduce N+1 queries in /api/v4/todos endpoint (!25711) · Merge requests · GitLab.org / GitLab FOSS

Merged Stan Hu requested to merge sh-optimize-todos-api into master 6 years ago

Viewing commit ea3aa03c

ea3aa03c

Significantly reduce N+1 queries in /api/v4/todos endpoint · ea3aa03c

Stan Hu authored 6 years ago

By preloading associations and batching issuable metadata lookups,
we can significantly cut the number of SQL queries needed to load
the Todos API endpoint.

On GitLab.com, my own tests showed my user's SQL queries went
from 365 to 65 SQL queries.

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/40378

Significantly reduce N+1 queries in /api/v4/todos endpoint

Merge request reports

Files