No video :(

Eloquent Performance Challenge: My Solution Version

Подписаться 143 тыс.

Просмотров 19 тыс.

50% 1

Yesterday I published a new challenge, and with 40+ Pull Requests from you guys, I already have something to discuss. So let's start with my own initial version of the solution, and in the upcoming video(s) I will discuss your PRs.
Challenge repository: github.com/Lar...
Related links:
- My course "Eloquent: Expert Level" laraveldaily.t...
- Laravel Foreign Keys: How to Deal with Errors • Laravel Foreign Keys: ...
- New in Laravel 8: withSum/withMax/withAvg on Relationships • New in Laravel 8: with...
- Laravel: Change Two Symbols to Boost Eloquent Speed • Laravel: Change Two Sy...
- - - - -
Support the channel by checking out our products:
- Enroll in my Laravel courses: laraveldaily.t...
- Try our Laravel QuickAdminPanel: bit.ly/quickad...
- Purchase my Livewire Kit: livewirekit.com
- View Laravel Code Examples: laravelexample...
- Subscribe to my weekly newsletter: bit.ly/laravel-...

Опубликовано:

14 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 92

@urosminic3401 3 года назад

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 3 года назад

Good tip bro

@blank001 3 года назад

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 3 года назад

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 3 года назад

6:47 wow! that was soo cool and satisfying

@nabeelyousafpasha 2 года назад

$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

@AliAwwad 3 года назад

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.

@bboydarknesz 3 года назад

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

@aldwynconjurer9449 2 года назад

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

@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

@nadeemahmed7947 3 года назад

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.

@arthurarw 3 года назад

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

@hmreluz Год назад

this video is gold, thanks !

@Matoxina 3 года назад

Clean solution, good job

@belce1982 2 года назад

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

@jimishukurow2286 3 года назад

Perfect example, like frrom me, respect man!

@bugszone6098 3 года назад

Best Video Ever

@ChangeYourLifeForever 3 года назад

Good solution, we need more challenges.

@freeeasyprogramming5151 2 года назад

Thank you so much really you are the best

@ward7576 3 года назад

That's a satisfying refactor.

@FririkurEllefsen 3 года назад

This is gold

@leoblanski Год назад

Amazing !!!

@raj-kal 3 года назад

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

@2am_yt 3 года назад

I love these challenges. Very satisfiying.

@dennisjmaina 2 года назад

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 2 года назад

That can be because of your webserver

@dennisjmaina 2 года назад

@@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 2 года назад

Use a different web-server?

@dennisjmaina 2 года назад

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 😊

@naazimkhan9953 3 года назад

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 3 года назад

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.

@GergelyCsermely 3 года назад

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

@EduardR10 2 года назад

Espectacular. Muchas gracias :)

@santiagos4290 3 года назад

very helpfull , thanks

@Stoney_Eagle 3 года назад

That's some eloquent queries 😉

@karimqasem7523 3 года назад

Thank u nice challenge ❤️❤️

@hiajayy 3 года назад

Very informative.❤

@taslimsuman 3 года назад

Great

@LaravelLover 3 года назад

Very important video thank you

@ritomukherjee8389 3 года назад

Greatness 🙏🙏

@josiasvelazquez1095 3 года назад

The best!

@alimransujon6388 3 года назад

Joss

@_passby5399 3 года назад

Awesome!

@Thead78 3 года назад

Parfait, merci :)

@avidian4759 3 года назад

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

@abhinavsingh7859 2 года назад

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

@iamriwash7943 3 года назад

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 3 года назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--77LnBSL2Zk.html

@amrqawasmeh 5 месяцев назад

Thank you for your amazing video

@Edvard-Aliev 3 года назад

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

@yusuperproactive9568 3 года назад

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

@satashanofficial 3 года назад

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 3 года назад

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.

@saktipujoedi8898 3 года назад

Nice

@franklintorres3717 2 года назад

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

@ujustwatch 3 года назад

Any video is there on parsing huge xml data in Laravel

@user-rm4zo1mg5o 3 года назад

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

@LaravelDaily 3 года назад

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

@donnaarisson7926 3 года назад

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

3 года назад

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

@abdulbasitsalah2918 3 года назад

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 3 года назад

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 3 года назад

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 3 года назад

@@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 3 года назад

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

@LaravelDaily 3 года назад

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

@delaneywright4751 3 года назад

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 3 года назад

"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 3 года назад

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.

@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!