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!

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store