Optimize top-level group MR list endpoint performance
## Goal Improve the performance of the top-level group merge request list endpoint to reduce error budget spend and increase system reliability. `GET /api/:version/groups/:id/merge_requests` ## Context The top-level group MR list endpoint is the primary driver of error budget consumption for the Code Review group. - https://gitlab.com/gitlab-org/gitlab/-/issues/552376+ - https://gitlab.com/gitlab-org/gitlab/-/issues/581541#note_2915869688 (internal) Previous optimization efforts in https://gitlab.com/groups/gitlab-org/-/epics/17943 have addressed low-hanging fruit to improve the baseline, this epic targets deeper performance improvements needed for meaningful gains. ## Success Criteria <!-- start roadmap:success_metrics --> * Improved apdex score for the endpoint * Decreased error budget spend for Code Review group <!-- end roadmap:success_metrics --> ### Internal Roadmap Information <!-- start roadmap:details --> https://gitlab.com/groups/gitlab-org/-/epics/20250#note_2951853280 <!-- end roadmap:details -->
epic