Code RoomOrder summary N+1 queries

MediumPrep Room Coding #2279

Order summary N+1 queries

Code reviewAlgorithms & data structuresMid–Senior~18 min

Review this code that builds an order summary.

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

1orders = Order.where(user_id=uid)

2result = []

3for o in orders:

4 items = OrderItem.where(order_id=o.id) # query per order

5 result.append({'order': o, 'items': items})

Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.