Review and improve 1st page response time for Projects API
In looking at API response for the projects API times I noticed there are very large response times for getting the first page for some parameter combinations.
I'd like to systematically capture 1st page response times for the projects API, analyze shortcomings and improve 1st page response times.
Note that pagination is orthogonal to this issue as we're talking about 1st page response timings here (with no pagination involved at all).
As a rule of thumb, I'd deem 1st page response times higher than 1s as unacceptable. While this still seems high, we currently have response times as high as 30s for some parameters.