Use Query or Find with Next instead of Count (LC0082)
When you need to get the count of records that match complex criteria, consider using a Query object or iterating with FindSet/Next. In some scenarios, this can be more efficient than using Count, especially when filters are complex or when you need to process the records anyway.
See also
- LC0081 - Use IsEmpty method instead of Count