Laravel Performance: Careful with withCount()

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

Links mentioned in this video:
Original tweet from Dries: https://x.com/driesvints/status/19655...
PR from tweet: https://github.com/laravelio/laravel....
Laravel.io Portal: https://laravel.io/
Laravel Docs on Counting Related Models: https://laravel.com/docs/12.x/eloquen...
My course "Laravel Eloquent: Expert Level" https://laraveldaily.com/course/larav...

Support the channel by checking out my products:
My Laravel courses: https://laraveldaily.com/courses
Filament examples: https://filamentexamples.com
Livewire Kit Components: https://livewirekit.com

Other places to follow:
My weekly Laravel newsletter: https://us11.campaign-archive.com/hom...
My personal Twitter:   / povilaskorop