Write Inside Loop (ARCH8052)

Key kotlin.orm.write-inside-loop · Severity error · Category orm

Flags save/insert/update/delete/flush calls inside a loop - one round trip per row. A batch/bulk write is excepted.

Incorrect

for (row in rows) {
    repository.save(row)
}

Correct

repository.saveAll(rows)

Fix

Batch the writes (saveAll, a bulk insert, one transaction) outside the loop.