Laravel DB Optimization: From 1.5k to 26 Queries

[@LoganathanNatarajanlogudotcom]

Good explanation and thanks for sharing.

[@Gideon933]

12:42 I will optimise the update condition by comparing a hash of the values in from the database to the hash of what was submitted to reduce the not equal to checks.

[@bowiemtl]

Impressive! :) First watched some of your Livewire examples but you definitely deserved your sub now

[@dclindner]

Nicely done! I have to say that it's this kind of challenge that makes me vigilant in the use of packages in real applications. Your example does a nice job in highlighting that you should not blindly use a package without first understanding how it works. Also, this should be a call-to-action to any package publisher---cursory review of code performance would have exposed this issue long before it was published.

[@sofian-_-7]

Nice video 👍 FIY, "locale" is pronounced same as "low kal" - I'm not native too, no worries 🤟

[@mushypeeze3545]

In English the letter "C" is often pronounced as a "K", as in Cow, Colour, but sometimes it's like "S" as in Ceiling. Regardless Povilas' command of English is extremely good considering it's not his native language and how ambiguous the English Language is

[@tiagotheoliveira]

Very nice video.

[@forever-zy3id]

ممنون

[@devKazuto]

And what was the baseline for just updating the records? 1.5k was creating the records, 26 was updating the records. Two completely different things and thus the title is misleading as 162 is the real value to compare against as this is the number of queries with `--fresh`.

[@LaravelDaily]

You're technically correct. Sorry for the misleading title.

[@chandraauliatama6384]

great video

[@yoyoypy]

this is gold

[@sepehrraftari2385]

Thanks for the video I think you could do another step of optimizing by using `createMany`

[@swilshobhit]

My Laravel 9 with livewire project not working in cpanel. Getting error in console : livewire not define. Plz help me how to resolve this. I don't have ssh access in my hosting.

[@LaravelDaily]

I don't recommend using hosting without ssh access, it leads to all kinds of problems like this one.

[@iliyasmsc]

which screen record do you use?

[@LaravelDaily]

Camtasia Studio on my MacBook

[@iliyasmsc]

@@LaravelDaily Thank you for replied.

[@MouffaqEjjah]

please how to use bootstrap 5 in breeze?

[@LaravelDaily]

You can't use Bootstrap in Breeze. For Bootstrap, use starter kit laravel/ui

[@streakifyapp]

Personally I find Laravel Telescope considerably more useful for debugging performance issues than Ray as you can see a breakdown of all queries (specifically which ones that might be slow, which are duplicate), jobs, etc.

[@mushypeeze3545]

I tried the php artisan translations:import --fresh command but got an " There are no commands defined in the "translations" namespace." error

[@LaravelDaily]

It comes from the package mentioned in the video, not from default Laravel.