Pagination offset performance
Review this SQL-backed paginator used to export all orders. It loops, bumping OFFSET, until a page comes back empty.
What a strong answer looks like
Separate real bugs from style. Rank issues by severity, point at the root cause rather than the symptom, and suggest a concrete fix, specific and kind.
0:00 of about 18 min
Mark a line and say what kind of problem it is.0 findings
1-- page N (0-indexed), page size 100
2SELECT id, customer_id, total, created_at
3FROM orders
4WHERE status = 'shipped'
5ORDER BY created_at
6LIMIT 100 OFFSET :n * 100;
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.
Run or narrate your approach, then ask the coach.