Laravel Performance | Be Careful with withCount()

My Account

Mijn Account

Mon Compte

Mein Konto

我的帐户

Inloggen

Connexion

Anmeldung

Acceso

Laravel Performance | Be Careful with withCount()

An example of query optimization using withCount vs join, also adding cache on top.

I have just done a similar optimize last week, removed a withCount with a join. I don’t know what MySQL is doing with subquery, but this looks like a n+1 problem.

To me it looks like MySQL is doing subquery on each main row, so time needed explodes, and internal cache in MySQL properly becomes tainted on larger dataset, so it explodes even more.

Just my theory, but the change is extreme

Laravel Daily

Povilas Korop

Laravel Performance | Be Careful with withCount()

Join the conversation 🎭

Laravel ] Supercharge Your Laravel App with Enums

Laravel Internal Live-Chat with Reverb and Livewire

Spatie Query Builder in Action: CMS Admin Panel Example

Nunomaduro | Laravel Core Dev Tries Next.js for the First Time

Laravel Daily | Laravel Boost: Add/Merge Your Custom AI Rules

Laracasts | Should You Learn Laravel Before PHP?

CodeSource | The Untold Story of Laravel

Josh Cirre | Why Livewire V4 Changes Everything

Laravel Boost | First Test with Real AI Prompt

Laracon 2025 | Dave Hicking | AI Will Not Replace You

Filament v4 is LIVE | Main Things You Need To Know

Laracon US 2025 | Denver - Day 2 Live Stream

Laracon US 2025 | Denver - Day 1 Live Stream

Claude Code vs Cursor | Head-to-Head Experiment Comparison

Alpine.js | Live Calculations in Laravel Blade

Laravel: Upload Large Files with Filepond and Chunks

Nuno Maduro | Filament 4 is 3 Times Faster?!

Laravel Daily | Top 5 Mistakes in Laravel DB Migrations

Laravel | Build an AI Chat App with Laravel

Laravel Daily | 3 Tools to Draw and Manage Database Schemas

NativePHP for Mobile | Demo Laravel Project

Laravel Daily | Top 3 Mistakes with Roles/Permissions in Laravel

Livewire in 11 Minutes | Main Things You Need to Know

Laravel Daily | 10 New Features in Laravel 12.x Minor Versions

Laravel Daily | I've Tried to Seed 10M Rows into MySQL...

New in Laravel 12.8 | Automatic Eager Loading

Laravael Filament 4 | What We Know So Far in April 2025

20 Laravel Features I Never Knew About

Laravel Daily | Use Filament as Laravel Starter Kit