N+1: Projects::MergeRequestsController#show CommitService::FindCommit

~Conversation: #321 (closed)

Accounts for ~25% of the calls to CommitService::FindCommit blocking us from enabling it at 100%

https://performance.gitlab.net/dashboard/db/gitaly-gitlab-rails-endpoint-invocations?orgId=1&from=now-30m&to=now&var-series=find_commit_gitaly_real_duration_seconds_count&var-environment=prd

See also https://gitlab.com/gitlab-org/gitlab-ce/issues/45190. If you work on this, please make sure that someone from the ~Discussion team is not working on it at the same time.

Edited by Andrew Newdigate
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information