medium10 pts · first answer countssystem-designapi-designdatabases
Paging through a huge feed
An API pages through 50 million transactions with LIMIT 50 OFFSET n. Deep pages are slow, and new rows cause duplicates between pages. What is better?
Discussion 0
Join free to post in the discussion.
Related questions
- 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
- Telling the client where the new item livesBackend Developer
- Filtering and sorting a listBackend Developer