Reduce SQL queries needed to load open merge requests (!22709) · Merge requests · GitLab.org / GitLab FOSS

The SQL queries and memory allocation in MergeRequests::RefreshService is dominated by queries for Project and Route loads. On staging, the absence of an inverse relationship caused Rails to make around 1100 extraneous SQL queries for the www-gitlab-com repository.

Relates to #49703 (moved)

Edited Oct 31, 2018 by Stan Hu

Reduce SQL queries needed to load open merge requests

Merge request reports