Improve performance of the Grape /api/projects endpoint
Per https://performance.gitlab.net/dashboard/db/controller-timings-overview?orgId=1&var-process_type=grape&var-action=All&var-database=Production&var-minimum_requests=10000&var-rarely_used=30000&var-commonly_used=100000&var-ignore_actions=%2F%5E(Gitlab::RequestForgery%7CRootController%7CMetricsController)%2F&var-minimum_p99=1000 this endpoint has a mean response time of 2 seconds, a 95th percentile of 5 seconds, and a 99th percentile of 23 seconds. We should try to reduce the mean to less than 1 second, and the p95/p99 within 2 seconds.
11th of September (2018) timings update:
- Mean time: 1s
- p95th time: 3s
- p99th time: 17s
Goal:
- Mean time: < 1s
- p95/99th time: 2s
Edited by Oswaldo Ferreira