Eloquent Performance: TOP 3 Mistakes Developers Make

I've talked a lot about Eloquent on this channel but decided to pick the three most common mistakes related to performance.
- - - - -
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

[@Stoney_Eagle]

When a TV show has casts, crews, posters, backdrops, translations, trailers and seasons, seasons has translations and episodes, episodes has translations and a video file and video file has a progress you learn quick to do all these eager loadings on the database level, not to mention using the right indexes on the keys your relations uses. That saves 2 to 5 minutes and 500mb on the worst case scenario 😅

[@Bevallalom]

In certain cases it's better to use raw sql then query builder. Also proper db indexing is important factor.

[@ihorchyshkala6325]

My rule:

[@PauloRicardo-dk6yf]

I am Brazilian and like very much your videos.

[@maxpower7735]

When using eager loading you may need to check if the data was loaded. For that Laravel has the function "relationLoaded".

[@belce1982]

Thanks as always. Saved to watch later. Keep the hard work!

[@corbitaltechnologies]

Very specific and detail example. Very helpful.

[@sodomousprime]

The last one is like when you have a HTML select input, where you only need the "id" and the "title" rather than loading all of the rest of the data. Good video, cheers.

[@ClCfe]

Model::pluck('title', 'id'); Be careful, do not do Model::get()->pluck('title', 'id'); As it does a Select * and then call pluck on the collection

[@nadjimmalade2847]

Exactlly i see a lot of people doing that.

[@exikoz]

Such great content! Thank you very much!!!!

[@shahosanandaji9894]

Thanks a lot again Povilas for making these videos.

[@anastasiospapadopoulos4612]

Thanks alot for these advices!

[@user-ej4dm2xq6q]

Very helpful. Thank you.

[@abdulbasitsalah2918]

i like how you categorize your video with the related topic for example in this video you prefix title with "Eloquent Performance:" it will be so good when someone search for performance in channel 👏👏

[@mahdihassannejad6157]

I should thank you a lot Povilas, I always start my day by watching one of your videos, And it would opens my mind along the day.

[@nurudeenqoyyumtimilehin5475]

Informative, thanks for sharing.

[@daleryanaldover6545]

Another way to explain $user->post->count() is that when we load a model either with relationship or not the returned data is a collection instance. And in the collection documentation we have ->count() method that counts data from the returned collection and not from databse.

[@user-rm4zo1mg5o]

One more important thing, it's very easy to use model $with variable to eager load relationship. But in much cases this data isn't used for example in model index. In that cases you can see how the performance decrease, specially with polymorphic relationship. It's better to retrieve relationships only for show and edit methods, where they will be really used, but not always through the model $with.

[@tim.bogdanov]

Whoa, this is huge, I've been using with incorecctly. Thank you

[@flyer0022f]

This was helpful, thank you

[@naturallifenow]

Great! I made the 3rd mistake too much when I made PDF reports that contained more than 10,000 records. Instead of creating a ReportResource with only the fields needed for the report, I used a Resource that returned all the fields in the table. For many records, it makes a total difference in the total size of json that the frontend needs to download from the backend.

[@rehmanghani6726]

Nice video Povilos 👍 Keep up the good work.

[@tukurhamid4703]

Thank you very much sir

[@jazzlevit]

Thanks, quite useful

[@arnaudbakyono461]

Wow, really good tips

[@muaazhammad4446]

thanks for these tips

[@masterpreshy9614]

Thank you.

[@afjalhusain302]

Thanks sir

[@RehmanKhan-zv2rl]

Great, I was always confuse to use relation with '( )' or without '( )', and also with eager loading, i have cleared the difference between that but can you please define more about eager loading and lazy loading and stuff like that, It would be really helpful. Thanks

[@YehudaKatz1]

I do filtering in PHP if whether the user can see an object is based on some permissions. For example, different users in a store have different payment methods available. I can't think of a simple way to filter that in the database. In PHP, you can use Collection::filter() to check if $user->can().

[@lahcenfahmi5361]

Thanks

[@GergelyCsermely]

Thanks.

[@nabeelyousafpasha]

Do you mind sharing those examples where PHP manipulation was seen more speedy than MySQL? Please share your experiences. Eager to learn more from you. Respect from Pakistan.

[@LaravelDaily]

I don't remember them, to be honest, it was a long time ago, I just remember the surprised feeling about it.

[@jing4625]

Thx

[@mouctechy]

Thank you sir for sharing it. I would like to know which front end framework do you suggest for a mid beginner of Laravel ? Live wire; vue, reactjs, jet-stream ,…..

[@RANJEETKUMAR-wz4dg]

thanks

[@sourovahmad4053]

Great as alwayes

[@user-xn4jg2fc5n]

Spasibo!

[@raphaeld7308]

you look like Mauricio Pochettino

[@henriquefriedrich5960]

Indeed :)

[@heyyy4987]

Awesome

[@mukhtarhussain2659]

amaizng

[@AbdelrahmanEl.Monshed]

good

[@pacykarz2009]

What is the better: $user->posts->count() or count($user->posts) ?

[@LaravelDaily]

Probably same

[@iliyasmsc]

Good,but how to get the user avatar in or other map fields in this query.

[@alislim6201]

am using join and leftjoin function in some cases instead of laravel relationship i find that way is better for me do you have any suggestions ?

[@rizkiakbar4866]

I new on laravel thanks for your helpfull video. How do u can view that's laravel process windows down there ?. I had no idea how to do that.

[@LaravelDaily]

Composer require barryvdh/laravel-debugbar

[@rizkiakbar4866]

@@LaravelDaily ooh it was composer library, I thought it was some new laravel feature. thanks

Hi Povilas, nice video. Which is your current stack for php/laravel development locally? I am using docker locally, but your video it seems very faster.

[@LaravelDaily]

Laravel valet on my MacBook

@@LaravelDaily Tks for the answer. It looks very good. Docker became lazy because of the sync of files between container/local env even using :delegated

[@jomonjohnson735]

could you review Encore\Admin\Layout\Content approach for rendering views ( from z-song/laravel-admin package)

[@LaravelDaily]

I don't think this individual case would be very useful for the audience.

[@jacquesmatike9289]

For the last case, I have a similar problem. In my database, I have almost 13.000 records of users. I have to process them all to get stats of users by checking an attribute value (0, 1, 2, 3). Loading data from database is fast, but process them in the foreach takes 40s. And obviously only that attribute and ID are loaded. Is there a way to do that operation for minimum time?

[@LaravelDaily]

Send me the code to [e-mail] maybe it's worth shooting a video about.

[@SanderCokart]

any alternative to debugbar for laravel + SPA configs?

[@LaravelDaily]

Laravel Telescope

[@abelenocrodriguez]

How would you do an API to debug this? Please, it would be very interesting to attack this type of problem, basically because my stack in more than 200 projects is always Vue.js and Laravel API

[@ashishdake1197]

@LaravelDaily I liked your videos much. Rather I say, I am learning Laravel by watching your videos only. I have a doubt. At 1:30, 2:25 or 5:05 you are showing us DB queries count and all DB queries. How can I see it in my browser. Is there any specific software or chrome extension for it? Also, please share list of all extensions and softwares that you use while development.

[@LaravelDaily]

It's Laravel Debugbar

[@suhpc82]

When you query only a select few columns of a relationship, should we do that within the with() call, or in the get() call?

[@gabrielilochi7840]

It should be within with() For example retrieving comment relation with required fields; with('comment:id,user_id,text,created_at')

[@suhpc82]

@@gabrielilochi7840 Thanks mate 👍

[@SanderCokart]

what is the benefit of compact() ?

[@LaravelDaily]

Shorter syntax for array

[@zafarbekbadalboyev9689]

Hi sir, thanks for tips. Can you tell us, is there any tool for REST API debugging for laravel like Laravel Debugbar?

[@anthoniG]

I think you can use Laravel Telescope. Don't quote me on that though as I am still relatively new to the whole Laravel experience.

[@LaravelDaily]

Telescope and Ray, a few videos about them: kzbin.infosearch?query=debug%20api

[@vitorfontoura5417]

You could use itsgoingd/clockwork. It has a similar feature to debugbar to add a footer with some request information, and in my opinion is a bit simpler than Telescope.

[@darkmode404]

I think you can still use the Debugbar but you have to use the backend url with /api/posts like localhost: 8000/api/posts

[@abuhenamustafamohammedsaha4386]

Using Withcount takes 5.15 ms whereas with eager loading it takes only 2.1 ms which one is better in terms of performance

[@noddychoi]

What should I do if I want to join across 4 four tables? The "hasManyThrough" seems only support 3 tables.

[@LaravelDaily]

Do manual ->join()

[@kuyapols4037]

May i know what is the package name or extension you use like inspect elements for laravel?

[@LaravelDaily]

Laravel Debugbar

[@kuyapols4037]

@@LaravelDaily Thank you for the noticed :D

[@kevinpallado9638]

What console log are you using for this?

[@LaravelDaily]

Laravel Debugbar

[@kevinpallado9638]

@@LaravelDaily can I use it when I only use laravel as an api endpoint?

[@bugsbunny4353]

Hi sir Can u make a video on upload large CSV in db fast using queue I worked on it its working fine but due to my server limitation sometimes queue fails

[@ClCfe]

Fastest: use mysql LOAD DATA INFILE Or laravel lazy collections + chunked inserts

[@bugsbunny4353]

@@ClCfe i am already using laravel jobs by breaking large csv into small files chunks then using jobs to save in background using particular user id

[@amitsolanki9363]

In laravel debugger What does the model indicate? Like models 300, like models 120

[@LaravelDaily]

The amount of Laravel eloquent models saved to RAM during this request.

[@amitsolanki9363]

How can I reduce amount of Laravel eloquent models

[@KevinYobeth]

How do we know if we create an inefficient query?

[@LaravelDaily]

Hard to answer in a KZbin comment. Emmm, you measure it against other possible queries?

[@vikymuhamad4226]

hi sir i still not understand about ur relasi using withCount(posts) and u get data in index using $user->post_count , and ur relasi name is posts , do u can tell me about $user->post_count coz ur name relasi is posts not post_count . thanks

[@LaravelDaily]

Laravel docs: laravel.com/docs/8.x/eloquent-relationships#counting-related-models

[@shaungbhone8368]

What happens when I don't solve N+1 problems? Someone helps. Thanks

[@salisu14]

App performance will be drastically reduced...

[@codingsense]

Good video thanks , can you please make a video on how to design a database digram I struggle a lot with it Please like this comment for him to see this

[@LaravelDaily]

I have a full course: laraveldaily.teachable.com/p/how-to-structure-database-in-laravel Also, an old video: kzbin.info/www/bejne/iJOudox6qdB0gKs

[@mmramadan496]

Excuse me, sir I have seen two methods in the Eloquent part are `fresh` and `refresh` BUT I do NOT know what is the benefit of these methods So, can you please explain more about these methods?

[@LaravelDaily]

Where exactly have you seen them, in what context? Can you give me the example/link?

[@mmramadan496]

@@LaravelDaily I can NOT send the link because every time I send a link it deleted So, search for `Eloquent: Getting Started` in the docs then you'll find the `Refreshing Models` title

[@MirzaBilal1992]

How to use laravel debugger ? Can you please assist me in this regard?

[@LaravelDaily]

Google "laravel Debugbar" and read its documentation

[@MirzaBilal1992]

@@LaravelDaily Thanks a lot for your kind reply. I have installed successfully.

[@hariomnagar5606]

Who can I test these kind of mistakes for API request or controller

[@LaravelDaily]

With Laravel Telescope

[@hariomnagar5606]

@@LaravelDaily Thanks I will try Telescope

[@chiragkumar6322]

How to secure .evn file in laravel.

[@LaravelDaily]

Don't push it to GitHub

[@chiragkumar6322]

@@LaravelDaily Thank you sir for reply. but actually my issue it is. I have make a Laravel 5.8 project In which many API are make for android APP. And one user find a bug his using our app and get some error. It shows the code of the .evn file. so how to secure .evn file to get any error.

[@sumanthapa4670]

Sir, I need to load 10 different kind from database news table based on their category which would be faste method 1:- $news_cat_1 = News::where('cat_id','1')->get(); $news_cat_2 = News::where('cat_id','2')->get(); . . . $news_cat_10 = News::where('cat_id','10')->get(); Method 2: $allNews = News::all(); $news_cat_1 = $allNews->where('cat_id','1')->get(); $news_cat_2 = $allNews->where('cat_id','2')->get(); . . . . $news_cat_10 = $allNews->where('cat_id','10')->get();