Is COUNT(*) slow in MySQL?

Aug 12th 2022 – aaronfrancis.com - submitted by Aaron Francis

database mysql optimization performance sql

Spoiler: it is optimized to be fast, and you should use it.

Read more [aaronfrancis.com]

← Scaling Laravel to 100M+ jobs and 30,000 requests/minute

Share Post LinkedIn | Follow @freekmurze

Join 9,500+ smart developers

Get my monthly newsletter with what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.

No spam. Unsubscribe anytime. You can also follow me on X.

Keep reading

My Claude Code setup 4 min read
Generate Apple and Google Wallet passes from Laravel 7 min read
Announcing laravel-sluggable v4 with self-healing URLs 5 min read
How we use Inertia v3 optimistic updates in There There 4 min read
Searching multiple columns with one URL parameter in laravel-query-builder 4 min read

Found something interesting to share? Submit a link to the community section.

I'm a Laravel developer at Spatie and Oh Dear. I maintain 300+ open source packages for the Laravel community.

Follow on X

Oh Dear monitors your entire website, so you don't have to. Uptime, SSL certificates, broken links, scheduled tasks, DNS, and more — all in one place.

Get instant notifications when something breaks, paired with a developer friendly API and thorough documentation.

Create a public status page in under a minute. Start your free trial.