Eloquent Performance Challenge: My Solution Version

[@urosminic3401]

Really nice challenge, a small tip, when eager loading you can also specify the columns you want from the relationship like this ->with('category:id,name'), it doesn't really matter here since in this case this is a very minor performance boost, but relationship could have like 20 columns, and this way you are loading only those you need for the query :)

[@LaravelLover]

Good tip bro

[@blank001]

Nice tip. This also reduces the data that is to be returned by DB, so less cpu intensive and also data transfer size is significantly low when transferring through Ajax.

[@pijushbarik]

I am not a PHP guy, I even don't like PHP. But I like to watch your videos, how you approach to the solutions, optimize things step by step. Thanks for your videos. Keep making ❤️

[@oshidipe]

6:47 wow! that was soo cool and satisfying

[@AliAwwad]

Thank you so much for this video, actually this was my first time using debugbar, and just following your tips I managed to reduce the queries in one of the pages from 800 queries to just 75 , and from 1400 models to 40 , also reduced memory from 26 mb to 15 mb. You are awesome. Thank you. Keep it up.

[@nabeelyousafpasha]

$object->relation = returns results for the relationship as result of sql query $object->relation() = returns query builder / eloquent instance on which one can perform other stuff. Respect from Pakistan

[@bboydarknesz]

This is best steps and very clear to refactoring query. Waw! Need more cases

[@nadeemahmed7947]

Thank you, wonderful explanation, you save my time once I googled how to minimize the number of query in model, but I didn't success, now I got idea how to optimize my queries.

[@aldwynconjurer9449]

It's a wonderful sample that show what we do and what wee must do. Thanks

[@arthurarw]

Excellent video!! Thanks for this. Your explanation is perfect and solve a lot of questions for me. Thanks!

[@belce1982]

Thanks as always. Mine is PR 48. And now I'm here to learn how to really improve it :)

[@kingstalker]

Lol love the fact that it says 1.42 sec and the vid takes 4 seconds to open the page hahahaha but thank this helped me a lot

[@jimishukurow2286]

Perfect example, like frrom me, respect man!

[@ChangeYourLifeForever]

Good solution, we need more challenges.

[@raj-kal]

Thanks for the video. I have learnt a lot from your videos

[@GergelyCsermely]

Thanks. Very interestin. I also forgot to check indexes.... :(

[@2am_yt]

I love these challenges. Very satisfiying.

[@hectorlavoepe]

this video is gold, thanks !

[@EduardR10]

Espectacular. Muchas gracias :)

[@dennisjmaina]

First of all, allow me give my loud of applause for your great content on laravel and programming generally. Your videos have really shaped my laravel skills 👏. I do have a problem when it comes to memory(debugbar measurement) which even in a small page with just 3 queries (perfectly optimized) doesn't still go below 23mb and page load speed at/around 200ms. Thank you

[@LaravelDaily]

That can be because of your webserver

[@dennisjmaina]

@@LaravelDaily might be, because even the login page with no queries and just 2 views, still goes at 23mb. Thank you for the response. Is there a fix to this though?

[@LaravelDaily]

Use a different web-server?

[@dennisjmaina]

This sure did work. On my local machine I'm running xampp server which seems to be the one with this problem. When i tested on a staging server running Lightspeed web server, everything seems to be stable. Thanks alot 😊

[@Matoxina]

Clean solution, good job

[@ward7576]

That's a satisfying refactor.

[@bugszone6098]

Best Video Ever

[@naazimkhan9953]

Hi sir, learn more alot from your videos. u use withCount and withAvg to a single relationship. Can you please make a video on aggregate relation methods like these and withSum for relationship's to relations like withSum('movies.category', 'column_name'). Thanks

[@LaravelDaily]

Hi, I don't really see the goal of doing this, you just use the same functions and pass different relationships to them, and experiment. Not sure if my new video on a different scenario would add some significant content that is unclear.

[@hiajayy]

Very informative.❤

[@leoblanski]

Amazing !!!

[@freeeasyprogramming5151]

Thank you so much really you are the best

[@FririkurEllefsen]

This is gold

[@Stoney_Eagle]

That's some eloquent queries 😉

[@LaravelLover]

Very important video thank you

[@karimqasem7523]

Thank u nice challenge ❤️❤️

[@santiagos4290]

very helpfull , thanks

[@ritomukherjee8389]

Greatness 🙏🙏

[@satashanofficial]

Hi Povilas, I learned a lot from you, please confirm one thing, while adding a foreign key you did not drop the column, it isn't necessary to drop a foreign key column?

[@LaravelDaily]

There are two different things: column and foreign key. So column existed but foreign key didn't. So there was nothing to delete, I just added foreign key to existing column.

[@iamriwash7943]

sir what about do not use refrence id but just do this $table->bigInterger('category_id)->unsigned()->index(); and in model define relation ??? does it slow ????

[@LaravelDaily]

The index() itself will help you to get faster query, yes. But you do need a foreign key to avoid incorrect data, watch my video about it: kzbin.info/www/bejne/Y2iafaF4iLFlkM0

[@Thead78]

Parfait, merci :)

[@josiasvelazquez1095]

The best!

[@avidian4759]

I didn't know there weren't foreign keys yet. I just assumed there would be. It was a mistake to do so hahaha

[@UnknownUser-ud1es]

What is the query and model monitor you are using in the video?

[@LaravelDaily]

Laravel Debugbar

[@abdulbasitsalah2918]

it's laravel debug bar just type in Google barryvdh/laravel-debugb-bar

[@UnknownUser-ud1es]

@@LaravelDaily Thankyou

[@UnknownUser-ud1es]

@@abdulbasitsalah2918 Thankyou

[@taslimsuman]

Great

[@_passby5399]

Awesome!

[@franklintorres3717]

Hi sir. Can I add a foreign key to the pivot table? if yes, how to do it? Thanks for advance

[@ujustwatch]

Any video is there on parsing huge xml data in Laravel

[@abhinavsingh7859]

Hello i am using laravel excel package and i have a little doubt, the excel file consist of students fee data, where they pay specific fee data. So suppose a student pay for tution fee, and hostel fee so there are two tables for that, one is parent table and another is child table. So suppose tution fee is 1000 and hostel is 500, the sum 1500 will be stored in parent table whose primary key will be stored in child table where fee details will be stored different rows, but it will be single row for parent table no matter how many payment student make it will only show the sum of amount

[@alimransujon6388]

Joss

[@abdulbasitsalah2918]

thanks povilas for this great tips 1-is there different between foreign and foreignId? because I always use foreignId I wonder which one is better to stick with it 2- take() and paginate() are some or different? because they both return specific amount of data in my challenge I used pagination

[@JuanMunoz-th3vn]

dude, with foreign you have to write unsignedbiginteger and foreign statement, but with foreignId, contains both lines , take seems like a LIMIT , paginate, is like a function that returns how many rows are, what page you are, etc sorry my english

[@LaravelDaily]

1. Foreign() just created the foreign key, so you have to separately create the column itself. ForeignId() creates both column and foreign key. 2. Well, they serve different purpose, take() adds LIMIT 100 to the SQL query, and paginate() takes the parameters from GET request, then adds similar LIMIT to SQL and then provides Laravel with features like ->links() to show in the Blade.

[@abdulbasitsalah2918]

@@LaravelDaily thank u and one little note, after i apply your solution, i notice that you did not add foreign key for category in movie table

[@abdulbasitsalah2918]

@@JuanMunoz-th3vn thank you, no your English is good

[@LaravelDaily]

Yes good catch, it wouldn't speed up much in this case, but also a good practice.

[@delaneywright4751]

I prefer to write my own SQL queries as opposed to eloquent I feel like when working with complex systems having allot of relationships defined in the model gets very complicated as opposed to just SQL. What are your thought's on this is not using eloquent in Laravel a bad thing as i almost never use it if I can help it?

[@youknowme9732]

"Eloquent models dispatch several events, allowing you to hook into the following moments in a model's lifecycle: retrieved, creating, created, updating, updated, saving, saved, deleting, deleted, restoring, restored, and replicating." (c) laravel.com

[@youknowme9732]

If our app have many visitors, we can optimizate this code with events hooks (on created new rating we can calculate Avg rating and save to Movie model, or create model like MovieStats - and run this code on diffrent threads), or move complex query to another server.

[@donnaarisson7926]

doesn’t ratings->count() automatically resolves to rating_count if the relation is eagerly loaded?

but then you eager load all the ratings, and you don't want to load them here, you specifically only want the count

[@amrqawasmeh]

Thank you for your amazing video

[@Edvard-Aliev]

Первый! Спасибо!

[@yusuperproactive9568]

Круто, что тут русскоговорящие есть

[@saktipujoedi8898]

Nice

[@KirillHybrid-f4f]

In my case same exactly same code requires 19MB of RAM always. Maybe it depends of the system.

[@LaravelDaily]

Yes, I will talk about it in today's video.

[@gssj-o8p]

Could you make it 1 query with a join on category? Is that good practise?

[@LaravelDaily]

Yes also ok, but then you lose Eloquent magic like accessors, as it becomes a Query Builder.

[@gssj-o8p]

@@LaravelDaily yeah I just watched a video where you explained this, about the differences of using query(). I'm watching all your videos, I just did a test and got the answer that I passed after being lay off my last job, I can safely say that, if everything go as planned as it seems like, you are one the biggest helpers here. Thank you so much for sharing your massive knowledge with the world!

[@Hello-mu1et]

What ide are you using?

[@LaravelDaily]

Phpstorm

[@Hello-mu1et]

@@LaravelDaily and what theme pls?

[@LaravelDaily]

Material Darker

[@Hello-mu1et]

@@LaravelDaily Thank you

[@mushnikov35]

Where can I get such a debugger?

[@LaravelDaily]

composer require barryvdh/laravel-debugbar

[@mushnikov35]

@@LaravelDaily Thanks

[@firdavs.ibodullayev]

What is the name of this Laravel debugger?

[@LaravelDaily]

composer require barryvdh/laravel-debugbar

[@firdavs.ibodullayev]

@@LaravelDaily thanks very much