Unbounded Query (ARCH8061)

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

Flags findAll()/SELECT-without-LIMIT reads that load a whole table into memory.

Incorrect

val everything = orderRepository.findAll()

Correct

val page = orderRepository.findAll(PageRequest.of(0, 100))

Fix

Page or limit the query; a table grows past what a single list can hold.