All challenges
Code AnalysisBeginner 60s

N+1 query in ORM loop

200 orders cause 201 queries. Fix?
Starter code
orders = Order.query.limit(200).all()
for o in orders:
    print(o.customer.name)   # lazy load -> 1 query each

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle