Avoid using size() in SOQL queries.xg

Impact Area

Performance

Severity

High

Affected Element

Apex Class

Rule ID #

SF-AVOID-SIZE-IN-SOQL

Impact #

Load large collections with SOQL in order to get total count using size() increase memory usage doing a negative impact in performance.

Remediation #

Use count() SOQL function in your query instead size() method in SOQL output list.

Time to fix

15 min

Was it helpful ?
Table of contents

THE AI CODE GOVERNANCE BRIEF

Sign up for new updates!