Count Vs Exists (ARCH8063)

Key kotlin.orm.count-vs-exists · Severity info · Category orm

Flags count() > 0 or findAll().size checks used only to test presence - the database can stop at the first row with exists.

Incorrect

if (repo.count() > 0)

Correct

if (repo.existsById(id))

Fix

Use exists / existsBy / LIMIT 1 for presence checks.