diff options
author | Stan Hu <stanhu@gmail.com> | 2019-03-02 09:31:36 -0800 |
---|---|---|
committer | Stan Hu <stanhu@gmail.com> | 2019-03-06 07:03:46 -0800 |
commit | 062efe4f7a83fb2b6d951b314692cca9ee8731cd (patch) | |
tree | 2907359acdf497130b38c75555056226189af829 /changelogs/unreleased | |
parent | a592a78072bb44fed1a25c25f2cabdc4cf4bc0bd (diff) | |
download | gitlab-ce-062efe4f7a83fb2b6d951b314692cca9ee8731cd.tar.gz |
Significantly reduce N+1 queries in /api/v4/todos endpoint
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 under 60 SQL queries.
Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/40378
Diffstat (limited to 'changelogs/unreleased')
-rw-r--r-- | changelogs/unreleased/sh-optimize-todos-api.yml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/changelogs/unreleased/sh-optimize-todos-api.yml b/changelogs/unreleased/sh-optimize-todos-api.yml new file mode 100644 index 00000000000..936ac31b853 --- /dev/null +++ b/changelogs/unreleased/sh-optimize-todos-api.yml @@ -0,0 +1,5 @@ +--- +title: Significantly reduce N+1 queries in /api/v4/todos endpoint +merge_request: 25711 +author: +type: performance |