Laravel Fact — Get model count

Pete Houston
Jul 30, 2016 · 1 min read

The question is very simple!

How to get model count efficiently?

Would you do like this?

Model::all()->count()Model::get()->count()

Oh, no! Those will execute the following query,

SELECT * from TABLE;

Instead, it should be running this query,

SELECT count(*) FROM table;

To do that in Laravel, call method count() on model,

Model::count()

That’s it and save the day!

Pete Houston

Written by

Code / Design / Love @ https://petehouston.com