I need to check the number of items in a collection without loading the full collection (as it has over 1.5 million items and causes memory issues).

Is there an efficient way to go about this?

  • Going threw raw count sql may be if it's juste to get a value ?
    – Claims
    Dec 3, 2021 at 13:52

1 Answer 1


You can use getSize() method for this.

Usage: $collection->getSize();

getSize() method execute a count SQL query into the database and give you the count.

You can read in detail by below article.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.