Unbounded Query No Limit (ARCH5061)

Key go.orm.unbounded-query-no-limit · Severity warning · Category orm

Fetching an entire table with no LIMIT or pagination risks memory blowup on large tables. Paginate the result.

Incorrect

var orders []Order
db.Find(&orders) // whole table loaded into memory
return orders

Correct

var orders []Order
db.Limit(50).Offset(page * 50).Find(&orders)
return orders

Fix

Add Limit and pagination to queries that feed a list or response to bound the rows fetched.