Projects API: Improve response time for `created_at desc` order and `visibility=internal`
Follow-up to #36390 (closed):
Those two requests perform noticeable different:
-
GET https:/gitlab.com/api/v4/projects?private_token=REDACTED&order_by=created_at&sort=asc&visibility=internal
(30s) -
GET https:/gitlab.com/api/v4/projects?private_token=REDACTED&order_by=created_at&sort=desc&visibility=internal
(2.4s)
Figure out why this is the case and if it's worth improving. How often do we see those requests?