All challenges
Code AnalysisIntermediate 50s

Trace: N+1 Detection

How many SQL queries does this issue for 100 users?
Starter code
users = db.query('SELECT * FROM users')
for u in users:
    u.posts = db.query(f'SELECT * FROM posts WHERE user_id={u.id}')

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