Optimizing Eloquent: Running Out Of Memory?

Very helpful, thanks

.4 of a second is terrible performance for such a simple set of queries.

I want to believe we can even make the performance better by paginating the data.

Very knowledgable video, thanks a lot.

hello using the livewire with modal, if we use the select using the sql table (ex: User:pluck('name','id')) when the page is loaded it will load all the models .. overloading the page .. how to make this load only when the modal is called
thanks

cool

thank you...

You are a genius. Thank you!

This is a game changer. Thank you great Boss

Thanks🌹

Thank you!

hey i have project i use egar losing every thing fine but for the 1st time it take time to load after it take 500ms . first time it take 10sec how to make ?

Is there any way to loop on 10 million records and sum the result in one column without getting out of memory exception? (all records in the same table no relation need to use )

Very very useful. thank you bro. 👏️👏️

Hi, thank you very much for a very useful video. I'm wondering about one thing, what is that you use for showing the Queries, Models, Routes ...etc, is it plugin or extension ? Please thanks for replying in advance.

Amazing! When working with the big amount of models, I usually use pagination instead of loading all at the first time.

Great video :)

Hello ! If I load query results on a variable which take place on memory, what happens if I leave the method where I was ? Do php automatically free up the memory or should I have to unset the variable myself ?
Thanks !!

hey how to do multiple theme system in laravel like wordpree . i have newsport and some client want new design for forntend . i dnot wanto to lose my old design for that I want to make theme system multiple how to do ???

How did you get a custom domain on localhost

Thank you!

What if you have to show 100k+ records
Or with parent child relation
Where you have 20k parents and atleast 2 child of each parent and have to show everything in one page without pagination like a report? What to do then?
Any help will be appreciated.

Thanks

Thanks a lot

thanks, very helpful!

That is really very helpful thnkss to u ..just i had a doubt why u used $hotel->bookings_count ...???? Is it mandatory or we can use whatever we want

Very Helpfull

I love you

hello thank you for all your video i would like to ask you please how can i change max file size in spatie media library to upload file more than 2 mb thank you

what's extentions used it ?

Hi. First of all I really enjoy watching your videos and am very thankful for your great free content. I am working on a laravel project where I need to schedule a task that deletes model instances daily and keeps a recond of when this task was run etc, how many deletes it made etc. . Can you make a video about Jobs, Queues and Task Scheduling with Laravel? I'm confused on if it's best to use Command, Job and Queue? Thanks!

wawwwwwww is really best

The only thing I regret not learning from videos like this is using select to select fields you actully need. One of the databases I work with has over 90 fields in orders table. So not limiting select got me pretty fast in hot water memory wise.

When using an Oracle database the IN Statement has a limit of 1000, so this way is no good for this Db .

Also, you could select only the columns you need depending on the size of your table if you have 50 columns and you only use 3 of them you can use the select function only get back the 3 columns in place off all 50.

How to optimize eloquent for jquery Datatables?

Povilas you are an amazing laravel tutor

Great tips about Eloquent. One more thing we can do is not to load * all data but we can put select() to only get required columns which we are going to show in blade view. It will also help to improve queries speed.

Please share the link of your video in which you have described why not to use "double" as data type for prices

This tut has great value. Thanks a lot!

additionally, memory usage can be decreased by avoiding select *

it's got to be a crime to have all these useful information for free sir ! i've got mad respect for you !

It’s an amazing tips, thanks by the way.
Dear povilas, I have a request to u to making a tutorial such cases I descibr below please...
Many of times we use ready template and they used many jquery plugin and also they have some custom jquery code. So when we trying to convert those theme to vue component system and in that time how can we used those plugin globally with vue or individual components. Thankyou again.

Amazing, went from 9 seconds page loading time to only 120ms! Combined withCount with a DB:raw('sum') and now its blazing fast and almost no memory! Thank you.

is this work in laravel 5.4?

And finally we can use pagination to limit the amount of data.

I still didn't work with laravel, just trying to learn to begin a project. Your tips are of great value.

I'm a code performance freak so this is like drug to me. It's also my curse because I won't publish my app untill it's perfect and that means longer production time and lower income. Any advice on how to work on this?

Thanks so much and i enjoy your tutorial every days.