Skip to content

ECO-CMP-JAVA-005

Name: N+1 ORM query pattern

Category: Computation

Family: Java

Primary layer: code

System layers: code

Description

ORM queries inside loops multiply DB calls.

Impact

  • confidence: 0.8
  • notes: Often severe at scale.
  • type: network

Detection

  • languages: java
  • method: hybrid

Remediation

  • guidance: Use eager fetching, joins, or batch queries.
  • tradeoffs: Tune memory and query plans.

Pattern examples

No pattern examples provided.

Remediation examples

No remediation examples provided.

Metadata

  • catalog_version: 0.4.0