ECO-CMP-PY-005 — N+1 database query pattern¶

Category: Computation (CMP)
Family: Python (PY)
Layer: Code
Tier: 2
Severity: warning
Tags: python, database, n+1
Legacy ID: ECO-PY-005

Summary¶

Queries executed inside iteration multiply round trips and load.

N+1 is a classic hidden multiplier for latency, cost, and carbon.

{
  "confidence": 0.8,
  "notes": "Often severe at scale.",
  "type": "network"
}

{
  "languages": [
    "python"
  ],
  "method": "hybrid"
}

{
  "guidance": "Use bulk queries, eager loading, or JOINs.",
  "tradeoffs": "May increase memory use; tune carefully."
}

{
  "system_layers": [
    "code"
  ]
}