Backend Engineer
One endpoint runs 101 queries.
- 1Your approach
- 2The follow-up
- 3Reflect & learn
THE INTERVIEWER ASKS
The scenario
A page returns 100 orders and each customer name. Database traces show one orders query followed by 100 customer queries. Diagnose and improve it.
How would you approach it?
Explain your assumptions, your approach, and why you chose it.