Faster Eloquent: Avoid Accessors with Foreach

Рет қаралды 52,023

2 жыл бұрын

In this video, step-by-step we will optimize a page loading from 30+ seconds to 0.2 seconds, by avoiding a foreach loop with Eloquent Attributes.
Spatie Ray: spatie.be/products/ray
My 20 Laravel Eloquent Tips and Tricks: laravel-news.com/eloquent-tip...
- - - - -
Support the channel by checking out our products:
- Enroll in my Laravel courses: laraveldaily.teachable.com
- Try our Laravel QuickAdminPanel: bit.ly/quickadminpanel
- Purchase my Livewire Kit: livewirekit.com
- View Laravel Code Examples: laravelexamples.com
- Subscribe to my weekly newsletter: bit.ly/laravel-newsletter

Пікірлер: 69

@gillesashley9314 Жыл бұрын

I believe this is by far the best laravel channel on KZfaq. Correct me if I'm wrong.

@BsiennKhan 2 жыл бұрын

All of this spesific talk was music for my ears. I love tips on performance tuning, not only performance wise, it also helps you to be a better architect or engineer by following patterns AND improving cognative skills for future projects.

@unarmedwombat 2 жыл бұрын

Possibly the single most useful tip I've seen this year. Thanks Povilas.

@Tooltrocity 2 жыл бұрын

This is a great video, I love learning performance stuff like this. It's the nuts and bolts of a tool that people don't talk about often enough. Please make more videos like this!

@LeonelViera 2 жыл бұрын

Nice that you elaborate your thinking process

@jacquesmatike9289 2 жыл бұрын

That's a huge optimization ! Thanks !!

@irvingviveros9314 2 жыл бұрын

New video = instant like! Thank you!

@abrpp 2 жыл бұрын

Always on point. Thank you!

@jamzykimani 10 ай бұрын

Awesome video👏👏 this plus the laravel-news article feels like a level up for me... So much actionable knowledge!!!

@obikwelukyrian6848 2 жыл бұрын

Watching your videos has made me an optimization freak tbh. And I'm not complaining 😊

@natenatters 2 жыл бұрын

Nice! Also, like you said at the end about caching, sometimes thats the best solution. You can use the existing logic and set an identity column inside of the User updating model event, then you bypass the need for an accessor.

@edsontomas8344 Жыл бұрын

Keep dropping them gems. Thank you

@rafa.alcantara 2 жыл бұрын

Povilas GOOD JOB, getting better day after day, Thanks for your incredible amount of work!

@leydergananbueno5466 2 жыл бұрын

Su canal es el mejor, he aprendido mucho de usted ¡muchas gracias! buen contenido

@devendergupta_official 2 жыл бұрын

A very good lesson!

@ChangeYourLifeForever 2 жыл бұрын

WOOW very intersting , we need more of those videos plz ( explain for us the eager VS normal ) loading data

@sachinvishwakarma290 2 жыл бұрын

Great and very helpful all your laravel video thanks 👍

@mikaelDzp Ай бұрын

thank you! you deserve more views !

@ahanafi-id 2 жыл бұрын

Great Video, thanks

@mohammadrezaarab7890 Жыл бұрын

It was really helpful. thanks

@alexandrelima5886 2 жыл бұрын

Great approach! Thx

@demeja16 2 жыл бұрын

It is so cool, thank you for this video!:)

@intipontt7490 2 жыл бұрын

I'm sure there's a perfectly reasonable sql query that returns the same results. This is a perfect example of when NOT to use Eloquent.

@Khalyomede 2 жыл бұрын

I completely agree with you. I recently found out when using "with('relation')", Eloquent will not perform an inner or left join, it will make a second "select ... where parent_relation in (all ids of parent_relation)", which for me was counter intuitive at first, but in the end to be able to have such a powerful chainable language you need to make some tradeoffs I guess. It still does the job pretty well to have a readable code!

@idonnow2 2 жыл бұрын

My first thought was to make a view in the DB lmao

@iamriwash7943 2 жыл бұрын

finally i got what i looking for ( thanks)😊

@koldovalnya 2 жыл бұрын

Thanks 4 tutorial

@MrJoboski Жыл бұрын

Amazing!

@darkmode404 2 жыл бұрын

Thank you!

@f00n168 2 жыл бұрын

Thank you 🙏🏻

@martinfeldman7340 Жыл бұрын

How can I add this video to some permanent list ? This is beyond excellent. Thank you so much Povilas!

@technical157 2 жыл бұрын

very interesting. thx

@devMoemen Жыл бұрын

very good thanks

@Shez-dc3fn 2 жыл бұрын

whats baffling me is he does select id from users but in attr he uses $this->name which i assume is an attr of that table.. :/ this name will always be null/empty since its not selected

@07Weka 2 жыл бұрын

He discussed and solved that in the video :/

@kkamarada4 2 жыл бұрын

Nice work o/

@TimvandenBelt 2 жыл бұрын

Once again, a great and educational video! Thanks! However, a small suggestion if you wish to push performance and be more strict with how the app deals with variables (less unexpected behaviour): use identical comparison (===) where possible. I noticed that for several comparisons where it should always be a comparison between two integers, a lossy equation (==) is used.

@p30mehrdad 2 жыл бұрын

Thanks

@ricko13 2 жыл бұрын

nuostabus, plojimai!

@SandorHorvathZ 2 жыл бұрын

Thank you so much for this video. Fantastic example how Laravel devs abuse Models nowdays.

@shahsawoodshinwari 5 ай бұрын

When I have to choose between a method on eloquent and an accessor, i check if there is any query launched to db, if yes, then it is definetly not an accessor as accessors are loaded on model load, while methods don't.

@mikegodz 2 жыл бұрын

Great video! Sometimes there's no reason not to do what the DB is designed to do. On the other hand, there are situation like the following: suppose you have a Posts/Comments project, and you want to show all the comments of a user, but visually divided by post. This is not a "SQL-grouping", cause you don't need to use some aggregate function on the data, but just to have them organized by post. On your opinion, what's a good way to handle these data? I am going with a foreach and an associative array, but doesn't feel right...

@LaravelDaily 2 жыл бұрын

Why is it not SQL grouping? When doing the query, you group by post_id, and then in the Blade do foreach ($post) -> foreach ($post->comments) etc.

@mikegodz 2 жыл бұрын

Because when you group by post_id (in SQL syntax) you aggregate the results using count, sum, etc. That's what I mean with "SQL grouping". Are you referring to using the groupBy function of Laravel?

@LaravelDaily 2 жыл бұрын

Yes I thought so, actually thinking about it, it's best to group in collection then, so something like ->get()->keyBy(post_id) or something, don't remember the exact collection method.

@mikegodz 2 жыл бұрын

@@LaravelDaily Didn't know about the keyBy method. I'll dive into it, thanks!

@hasanbaig1540 2 жыл бұрын

That's really important topic to follow in development. If you have the right tool then task seems more interesting to do. I haven't found the name of this debugging tool in description please share the link.

@LaravelDaily 2 жыл бұрын

Composer require barryvdh/laravel-debugbar, also Laravel telescope and Spatie Rsy - those are the tools

@GergelyCsermely 2 жыл бұрын

Excellent. Could You please link the Ray setup video? If I'm not mistaken You have a nice presentation.

@LaravelDaily 2 жыл бұрын

kzfaq.info/get/bejne/pJqggNuqpr7JoY0.html

@GergelyCsermely 2 жыл бұрын

@@LaravelDaily Thanks

@MrFa321 2 жыл бұрын

Which server are you using in mac for running laravel applications? Like xampp or any other?

@LaravelDaily 2 жыл бұрын

Laravel valet

@martinlionel7487 2 жыл бұрын

Good video. The most erreur is : use trust orm and don't know how bdd work

@murr3540 2 жыл бұрын

I have an issue, i don't know if its laravel or db issues, but if idle for a certain period of time and tried to retrieve data on the database I got like 1.5k to 3k ms , but on 3rd or 4th call its like on for 400ms, same records it was same records, and I'm using mongodb.

@AbrarAhmad-mz8vl 2 жыл бұрын

So basically it is issues with queries itself, not with accessor. Is it? If I'm using just get modify date format will it perform bad too?

@hungrybox2100 2 жыл бұрын

Can you please make a video on recursive function when category needs to be display in hierarchy? Because it causes performance problem

@LaravelDaily 2 жыл бұрын

This video should help: kzfaq.info/get/bejne/a9ldkrafu9KRYZs.html

@teb1687 2 жыл бұрын

why are comments being deleted?

@LaravelDaily 2 жыл бұрын

I haven't deleted any comments, except for obvious spam bots

@teb1687 2 жыл бұрын

@@LaravelDaily ok must be some yt issue

@novichkovv Жыл бұрын

Why don't you use laravel ide helper? My perfectionist eyes are bleeding seeing those inspector warnings. But besides aesthetic aspect, ide helper really improves the quality of code by avoiding typos and development speed by autocomplete. I always try to make each php file having green inspector mark, thus, especially if you use type hints, return types and declare strict, green mark says that everything here is correct and you need to pay attention only to the logic