Laravel: Change Two Symbols to Boost Eloquent Speed 

My day starts with laravel daily

Finally someone explained the difference between call the relationship as property and method.

Laravel should reward you, you are increasing the numbers of Laravel Developers!

laravel daily is turning to my first todo in the office

Probably the most useful Laravel video of all time

This small series on performance boosting an application using eloquent is a life-saver. Cant thank you enough mate..Such a to the point and professional approach. Long live😍

Amazing insight. Never seen it explained this clear and this obvious before. Keep on sharing!

This is incredible, I imagined something like this but I wasn't sure about it, thanks for sharing this information.

This tip saved my project !

I had to watch this twice but now I've got it! Great lesson. Thank you.

it's worth noting that without the parentheses, you are returning a Laravel Collection of the related models. So the where() method was actually a Collection method, not an Eloquent Query Builder method. The Collection where() method is filtering out all the elements (Eloquent model objects) in the Collection loaded from the database which does not satify with the conditions in the where() method. Like what you had suggested, using the parentheses will return an Eloquent Query Builder, and the where() method is actually a Query Builder method, thus it actually performs a where query. Understanding this allows me makes better choice if I really want to load ALL the data from the db first then process the data or do I want to select the data from db specifically based on condition so I would get the actual data that I want from the db. Because sometimes, we do find ourselves in a situation where we need to get all the data first and then filter out the data into different categories. For that I think doing it in a single query is much better than multiple queries. Another tip is, if you manage to get the data that you want by filtering out a Collection of data, try to get the same data using a single query. The performance gain is worth the effort, even though if you have to use DB facade query builder. cheers!

Very good example, the confusing part for junior laravel developers is that 'where' and 'count' and other methods work BOTH on query builder and eloquent collection but logically it is two different things with same names. Just have to get used to work with query builder and its result - eloquent collection; and understand when query builder might become an eloquent collection, that's also important.

Olá .. mais um excelente vídeo. Durante a criação de aplicações, poucos desenvolvedores se preocupam em usar todo o potencial que um BD pode oferecer. Unido a uma boa ferramenta de ORM, as aplicações serão tão rápidas quando possível. Obrigado por compartilha seu conhecimento.

i used to do this all the time Povilas, now i know better thanks to you!

I have to send this to all my friend!! This is really awesome trick.

Best laravel channel ever:)

The best laravel advice I had since long time 😁

Great logic , I was very much worried to my query in recent day, just I came back to my home and noticed your video , then tried to implement in my project , what great concept , Thankyou.

Dude. Your content is amazing and keeps me motivated to learn even more Laravel. Thank you so much!

I'd try the way you shared here. to reduce the model counts I use the 'toBase()' it basically doesn't prepare the model, downside is anything you have in model like a specific function won't work. Thanks for sharing , all of your videos are helping me make things better. :D

You have withCount() for the initial query eager loading if you do need count

Amazing! Now I know why, I started caching to counter this behavior. Thanks!

I knew that problem will be with parentheses :D It's a common problem that many people do :) Your video forced me to install Laravel Debug Bar :D

Amazing tip. Such a small thing but makes a massive difference. Thanks for sharing it :)

Very good tips. Thank you

This is the kind of thing that is worth it! thank you for your time and your knowledge. Very well explained and very straight to the point!

Thanks for the amazing tip and explanation. Always look forward to your videos.

Hi 👋, that's really cool. To boost performance and enhance caching, you can create a new column in the product table "stock_left". Each time an order is created, you decrement stock_left. When the stock is added you increment it. By doing so you can easily get that data in a large listing without any performance issue.

Thank you for daily useful videos.

So simple but such a great tip! Seeing it explained makes so much sense.

This guy is genius ! Respect

Thanks for the tips, you're making developers life easier.

Honestly this is what sets people apart from people who actually know laravel and people who don't

Please more please please make more,You are the tricks boss

Thank you. I am about to implement same logic to show the remaining stocks.

Because Laravel collection and Query builder collection works same, almost same methods. It's hard for newbies to differentiate b/w

I just started replacing a whole bunch of "User::all()" calls ... 🙈🙈🙈 THANK YOU!

this is very useful tip, thanks you for sharing that with us

i like to add a trigger to orders.products table to decrement products.stock with each row inserted , another trigger before update on Products to generate error if new stock value is negative .. this way u wont need t calculate remining product and avoid potential problems cuzed by race condition

Wow, returning a query builder instance instead of a giant array is great

Excellent tip, will try to keep this in mind

Thank you very much for this, that's really important

This is very helpful and important tips

This reminds me a bit about pagination. When you do pagination are you making the query faster because you're asking to load a specific amount (i think max is 15) of resources as opposed to "all" ? Very useful trick. Thanks!!

Thank you for this is just gold

Dummm 🙉. This guy is really awesome. I follow you since 2018 in i guess i used to see all ur videos. Learned alot with u. Thankz 4 all

Wow!! I will have to take note of this and check my current project for this mistake 😅

Thank for sharing the tips

very nice, thanks so much for your sharing

Always helpful, Thanks for your great work

amazing, Small But Super Power Full Tips

make a small project on how to handle appointments (e.x. a clinic) and how can we implement Google Analytics in the dashboard please.

Great tip. Thank you so much for sharing:)

Really, really informative stuff! Thanks.

thank you very much. very helpful

Mind blowing! Thank you!

You are Great teacher, Thanks

There is the opposite problem where one hardcoding queries and causes N+1 afterwards. If you want eager loading capable code you have to consider using getter or relationship attribute on intermediate level thus allow the upper level eager loading, speeding up drastically certain code

Amazingly important small useful tip not in mind while developing.

Thank You. Very good tip.

Thanks man! Your content is awesome

Amazing. I've been doing laravel at work for the past few months and didn't realise this. Thanks! I have a question though. If it's only a one to one relationship then does it matter if you use the () after the relationship since it would only ever get the one item?

Thank you

there are too many people who don't know this, there are probably more who don't know than know, the query time effect won't be obvious if you don't have thousands of data, most junior developers don't work with such huge data, hence they never know

شكرا جزيلا

Hi sir, How can be one to many relation on stock.. One product can have on stock...

Great Tip thank you!

thank you

That's amazing.

Great tip.

that is awesome. Thanks!

thankyou you have a new subs

Great! Very very usefull! Thanks

Pov, I think you should do another video on this topic. I was watching a Laracasts video not so long ago and Jeffrey Way mentioned this exact thing, the difference between the method being treated as a property versus a function, but I would have liked more detail.

thanks!

amazing, thanks so much.

Another great video! Can you please upload a video of useful chrome addons you are using?

thank you so much really, you are professional

🔥👏🏻 thanks for sharing

Wow, thanks a lot.

Very Good Videos ;) Thank you.

whooooola Amazing tips... if you can make a video on Persisting sessions across subdomains in Laravel.. share session/cookies across all subdomain and how to get them. also if the subdomain has it own session and to make the subdomain make you of the main domain session concurrently

Can you repeat the same with like 1000 records and check how many queries does it generate ?

at 2:51 what do you have/use in the inspect section to get the queries, route, models. pls and thank you

like eager load ?

Thanks Sir!

Thanks

Hey I have started learning Laravel because of your code review videos and now I'm following every video. I would like to know which plugin are you using for the type hinting when you call a method? Thanks in advance.

Wow good work. I have a question. How to manage guest users and Auth users in Restful APIs. All APIs makes secure. Nobody calls APIs using POST man and perform any action. if we are not apply auth middleware then all APIs secure less and anybody perform action. If we apply auth middleware then user must registered in my system and then use App. For example in App, user ABC login as a guest and place order using App (IOS,Android), after user ABC register in my system and properly logged in then how to manage orders and others data which is saved as a previous data when login as a guest?

Thank you thank you thank you

Thanks!

All i can say is thank you .

Extraordinary

what does extension is it?

Awesome!

I just made a fresh laravel install and displayed the homepage (welcome.blade.php view) from routes.php no DB no controller, but the Debugbar package shows 17MB.. I wonder how did he drop it down till 5MB, i mean it should be at least 17MB because it seems like the Laravel booting alone consume 17MB of memory. Can anyone explain me how did he manage to do so ? Thanks

Hi, i'm getting Call to undefined method Illuminate\Database\Eloquent\Builder::addEagerConstraints() error while calling like this, Booking::get()->load('getPackage','getServices'); in my booking model public function getServices() { return Services::whereIn('id',explode(',',$this->extra_service)); } i saved extra_service value in comma seprated string can anyone help me to solve this?

True

You are really amazing 👏❤

Thanks for the video. I have à question for anyone willing to help, In this kind of app, say we want to get the remaining stock of each product for each store (or location). For a database with 100 store, 5000 orders per store and 10 shared products. would it be a good idea to cache the remaining stocks or Just calculate it at every page refresh? I implémented à kind of caching but seeing the app performance in the video i might Just save the hassle and calculate the stocks. Ps: I know it may depend on stuffs like count of reads/writes but what do you guys think ? . Thanks