Avoid using size() in SOQL queries.xg

< 1 min read

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

Updated on March 21, 2025
Table of contents
Was it helpful ?