Profiling for N+1 Queries - Build Expense Tracker App With PHP 8

In this video we learn about eager loading & how to fix n+1 problems. We use a tool called Clockwork to do the profiling.
SOME OF THE WAYS YOU CAN SUPPORT THE CHANNEL
👍 Smash the like button
🤝 Subscribe to the channel & turn the notifications on
💬 Post comments, any feedback is greatly appreciated
⭐ Become a Patreon: / programwithgio
THANK YOU!
🛠️ TOOLS & SERVICES I USE
Digital Ocean Hosting - Get 100$ credit - m.do.co/c/38b9...
Domains on Namecheap - namecheap.pxf....
Envato Elements - 1.envato.marke...
LESSON P.23
Starting Source Code - github.com/gge...
Ending Source Code - github.com/gge...
Course Outline - github.com/gge...
Course Playlist - • Learn PHP The Right Wa...
Clockwork - underground.wo...
** Affiliate Disclaimer: Some of the above links may be affiliate links, which may generate me a sales commission at no additional cost to you.

[@khushisoni295]

Please launch laravel course.....

[@ProgramWithGio]

I will start working on it once we finish the PHP series. Can't do it at the moment because I don't have a lot of free time unfortunately

[@ProgramWithGio]

@Muhammad Alsoofi about 10

[@FGj-xj7rd]

Eager loading saves the day.

[@ProgramWithGio]

For sure

[@bakosyy]

Hi Gio. How do know what basically do clockwork's ->setStorage(), ->addDataSource() methods and what parameters it may potentially accept? I could not find those details in documentation and I am wondering how can we know such things?

[@ProgramWithGio]

hey, I'm not sure to be honest. You could inspect the source code and see

[@Zubbee]

Oh wow. This is great stuff Gio. Thank you so much!

[@ProgramWithGio]

🙌🙌

[@AnhNguyen-z5u8o]

thank you so much, your work is freaking awesome

[@ProgramWithGio]

You're welcome, thank you

[@Zubbee]

I 2nd that

[@bulent2435]

nice

[@ProgramWithGio]

🙌

[@free2idol1]

Hi Gio,
Is this tool better than Laravel Debuggbar in terms of profiling for N+1?

[@ProgramWithGio]

Laravel Debugbar is for Laravel, Clockwork can be used in other frameworks as well. Debugbar is great for finding how many models are hydrated, also can find out n+1 problems, etc. I do prefer clockwork though & when I work in Laravel I also have telescope always installed

[@free2idol1]

@@ProgramWithGio Thanks... Apart from Laravel and Slim, what are your preferred php framework? I understand Laravel is very popular but in which scenario you would NOT choose Laravel in your project?

[@Zubbee]

Hi Gio, this is new stuff. Being able to look into performance is amazing Gio. I see lazy loading functions too, I guess those also have advantages in its own way to help performance when working with large data. These adjustments really require careful thought. Thanks for this lesson Gio.

[@ProgramWithGio]

🙌🙌

[@josechirino5168]

Can you please make a video about this with vanilla php for has-many and many-to-many relationships? I'm not sure how to do it without a orm

[@ProgramWithGio]

We would essentially be building an ORM from scratch then if we start hydrating objects and implementing relationships between them.

[@Ebedx6]

Wow

[@ProgramWithGio]

🙌

[@sym2574]

Does this course replace buying a PHP course on Udemy?

[@ProgramWithGio]

I would hope so

[@morteza55510]

Yes of course,
I did watch a course about php in Udemy (about 30 to 40 hours), and I can say that this course is even better then the courses on Udemy

[@rustavellyne]

Why do you use Brave bowser?

[@ProgramWithGio]

Built in ad blocker & works better for me

[@free2idol1]

@@ProgramWithGio is it developer friendly?

[@ProgramWithGio]

@@free2idol1 its chromium based so if you like chrome you will like brave as well.