Query Inside Loop (ARCH4064)

Key java.orm.query-inside-loop · Severity warning · Category orm

Issuing a repository/query call on every loop iteration (broader than relation N+1) produces needless round-trips. Fetch the data with one batched query.

Incorrect

for (Long id : userIds) {
    User user = userRepository.findById(id).orElseThrow(); // query per iteration
    process(user);
}

Correct

List<User> users = userRepository.findAllById(userIds); // single query
users.forEach(this::process);

Fix

Move per-item find/aggregate calls out of the loop into a single batched query.