Optimize Laravel Queries & Reduce Memory Usage for Faster Performance | Laravel Query Optimization

[@HafizurRahman-g4w]

Awesome explain. Thanks. We want more video on query optimization

[@seppdaniel]

You should not COUNT('id'), but rather COUNT('*') and thus let database decide which column is fastest to count.

[@laravelschool]

I totally agree. It's a good point @seppdaniel BTW.
However the performance difference between `COUNT('id')` and `COUNT(*)` is negligible, especially when 'id' is the primary key and non-NULL values.

[@tanzimibthesam5861]

Awesome btw do you intend to cover database indexing in any future videos n how to implement it in Laravel

[@laravelschool]

Thank you for your comment.
Creating *index* is straight forward. Therefore I didn't cover it here. FYI: laravel.com/docs/10.x/migrations#creating-indexes
I have plan to cover it to other video in different context, not for this scenario.

[@markbarton6845]

Thanks for this great example of refactoring problem queries. I’d love to see an example of the database indexing you mentioned as this is not something many people seem to demonstrate.

[@laravelschool]

Thanks for your comment. I will consider to create another video for that.

[@KishanKumar-jp7ee]

We want more video on query optimization

[@programmertelo]

amazing stuff

[@WebWordsWave]

which theme and font?

[@aizazaziz5636]

Hi, Please share source code for this

[@kinvain]

YAN1FT = Yet Another N+1 Fixing Tutorial.