What is the fastest way to count all the records of a table using Doctrine ORM?

Question

Hi,

The title says it all... What is the fastest way to count all the records of a table using Doctrine ORM?

I don't need the individual records of the table. I just need the total number of records in the table.

Thanks!

Answer 1

The fastest is likely to bypass Doctrine and use raw SQL, but you can do:

Doctrine::getTable('tablename')->count();

Also see:

• Doctrine Manual on Data Retrieval and Manipulation