ECO-CMP-PY-015 — Recreating database connections per request¶

Category: Computation (CMP)
Family: Python (PY)
Layer: Code
Tier: 2
Severity: error
Tags: python, database, connections
Legacy ID: ECO-PY-015

Summary¶

Creating DB connections per request increases latency and resource churn.

Connection setup is expensive and can overwhelm DB under load.

{
  "confidence": 0.85,
  "notes": "High propagation; often causes outages.",
  "type": "latency"
}

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

{
  "guidance": "Use connection pooling and reuse sessions/clients.",
  "tradeoffs": "Requires lifecycle management."
}

{
  "system_layers": [
    "code"
  ]
}