Unbounded Query No Limit (ARCH3061)

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

Fetching an entire table with no LIMIT/pagination risks memory blowup on large tables when the result feeds a list or response. Always bound the query.

Incorrect

async function listUsers() {
  return await userRepo.find(); // entire table
}

Correct

async function listUsers(page = 0, size = 50) {
  return await userRepo.find({ skip: page * size, take: size });
}

Fix

Add take/limit and pagination to bound the number of rows fetched.