hard20 pts · first answer countsapi-designpaginationperformance
Every page load counts 80 million rows
GET /events?limit=50 also returns total, computed with COUNT(*) on an 80-million-row table, and it is the slowest part of the request. What is a common API design change?
Discussion 0
Join free to post in the discussion.
Related questions
- Slow email during signupBackend Developer
- What EXPLAIN tells youBackend Developer
- Response for a successful DELETEBackend Developer
- A product page removed for goodBackend Developer
- Signing up with a taken usernameBackend Developer
- Calling DELETE on a read-only routeBackend Developer
- A client posts XML to a JSON APIBackend Developer
- URL for one productBackend Developer