Тёмный

Drastically Improve Query Time From 4 seconds to 70 milliseconds (50 - 60 times faster) 

Laratips
Подписаться 18 тыс.
Просмотров 50 тыс.
50% 1

In this video, we will learn how to MySQL indexing to increase the performance of our application. By adding an index to a column you can drastically improve the query time of your application.
=== Important Links ===
Fonts, extensions I use, and Support Laratips links:
bit.ly/m/laratips
=== Offer ===
Laravel Hosting: platform.cloudways.com/signup...
Get up to Free Hosting by using code "LARATIPS" and you get $15 as credit which can last almost a month.
Cloudways offers peace of mind and flexibility so you can focus on growing your business and reaching new milestones instead of dealing with server management. With Cloudways, you get an optimized stack, managed servers, backups, staging environment, integrated Git, pre-configured, Composer, 24/7 support, and the choice of five cloud providers: AWS, DigitalOcean, Linode, Google Cloud, and Vultr
====================== Support ======================
If you want me to continue making this kind of video for free on RU-vid, then you can support the channel
eSewa ID: 9843632084
Wise Link: bit.ly/3dnBRmX
Wise email: ashish.dhamala2015@gmail.com
===
Let's be friends:
/ aashish_dhamala
Tech stack:
Laravel
PHP
MySQL
#laravel #php #mysql

Опубликовано:

 

26 май 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 48   
@Laratips
@Laratips Год назад
Get $15 credit by using code "LARATIPS" which can last almost a month. Cloudways Web Hosting: platform.cloudways.com/signup?id=1029148&data1=bw&coupon=LARATIPS Cloudways offers peace of mind and flexibility so you can focus on growing your business and reaching new milestones instead of dealing with server management. With Cloudways, you get an optimized stack, managed servers, backups, staging environment, integrated Git, pre-configured, Composer, 24/7 support, and the choice of five cloud providers: AWS, DigitalOcean, Linode, Google Cloud, and Vultr
@Laratips
@Laratips 3 года назад
Hey Guys, just wanted to share that don't go and create many indexes in your application. There is one downside of it as well. Yes, it increases the read performance of your application but it will decrease the write performance. It means when you store something in the table with lots of indexes, it will take a lot of time to actually store the data in the table. So, if your application does more reads than writes, you can add more indexes but the lesser the indexes better it is. Also, always check the performance of your application and roll back if necessary after adding an index.
@BraderGeoYT
@BraderGeoYT 2 месяца назад
I'm applying as a Laravel Developer for my next job and this really helped me alot to prepare and this is very useful thanks for the tip!
@VitorJustin
@VitorJustin 3 года назад
Great tip! Tks for sharing!
@johnp6115
@johnp6115 2 года назад
Thanks for the tip, awesome!
@musicfactoryPH
@musicfactoryPH Год назад
Very big help. Thank you so much
@Laratips
@Laratips Год назад
You're welcome!
@OnlinePseudonym
@OnlinePseudonym Год назад
Really insightful - thanks very much 🙂
@Laratips
@Laratips Год назад
Glad it was helpful!
@alnahian2003
@alnahian2003 Год назад
Cool! Learned something new and helpful.
@Laratips
@Laratips Год назад
Glad it was helpful!
@sri3235
@sri3235 Год назад
Thank you
@vmmismagic
@vmmismagic 2 месяца назад
amazing explanation!
@mirshodmustafoyev2524
@mirshodmustafoyev2524 Год назад
What happens if we use second query for non indexed data ? Gets less time than 4s or not ?
@hizkielputra1195
@hizkielputra1195 Год назад
thank you
@nathanstanfordsr
@nathanstanfordsr Год назад
awesome tip thanks
@imranlashari6578
@imranlashari6578 3 месяца назад
@laratips what about if i am using vue js as frontend and laravel as backend, i need to check every API call query execution time to optimize it
@diomandesouleymane6621
@diomandesouleymane6621 3 года назад
Great tip
3 года назад
great leson
@Laratips
@Laratips 3 года назад
Thanks
@MudassarYaseen
@MudassarYaseen Год назад
Great
@fahathamm3965
@fahathamm3965 3 года назад
Can i use collection for cout... if i use collect how much kuch sec take it.. which one is better..? Thank you recent addict laravel channel one of the subscriber
@Laratips
@Laratips 3 года назад
Always use eloquent or database layer instead of collection if possible. The time taken depends on how many data u have in collection. You can check the time by logging the time before and after the collection execution. Thanks for subscribing. ♥️
@lchig0
@lchig0 Год назад
Great vid buddy
@Laratips
@Laratips Год назад
Thanks
@LukePighetti
@LukePighetti Год назад
What tool are you using to show the Laravel query performance?
@Laratips
@Laratips Год назад
It's a laravel package called Laravel Debugbar
@farhanisrak8688
@farhanisrak8688 4 месяца назад
Can you please tell which extension you're using for checking those queries?
@fatchurrosi4386
@fatchurrosi4386 4 месяца назад
using laravel debug bar
@farhanisrak8688
@farhanisrak8688 4 месяца назад
Thanks @@fatchurrosi4386
@shahriyarhosseinzadeh4409
@shahriyarhosseinzadeh4409 11 месяцев назад
Hey , please turn on subtitle
@Vikaskumar-ur5di
@Vikaskumar-ur5di Год назад
which package are used in laravel debug
@Laratips
@Laratips Год назад
Laravel debugbar
@bhavyakumarpanchotiya8254
@bhavyakumarpanchotiya8254 3 года назад
What is use of Carbon ...make the video on that..
@Laratips
@Laratips 3 года назад
It is basically a wrapper around PHP's DateTime class but much more readable api. Sure I will make one. Thanks for the video idea. :)
@bhavyakumarpanchotiya8254
@bhavyakumarpanchotiya8254 3 года назад
@@Laratips Thank you sir
@ramonm8039
@ramonm8039 3 года назад
What is the name of the tool to see Queries??
@julienSibille
@julienSibille 3 года назад
Laravel debugbar
@ramonm8039
@ramonm8039 3 года назад
@@julienSibille Thanks!
@taskinurrahman6650
@taskinurrahman6650 Год назад
Use count(id) instead of count(*)
@impostor8984
@impostor8984 10 месяцев назад
no
@Xaero324
@Xaero324 9 месяцев назад
This has been debunked. That may have been true very long ago, however, DBMS are now optimized and would prefer you use count(*). In short: count(*) !== select(*)
@BijayaNamna
@BijayaNamna Год назад
Are you from Nepal ? You accent seems like that
@Laratips
@Laratips Год назад
Yes
@kapadiajanak
@kapadiajanak 3 года назад
Laravel socket io lesson
@tusharnain6652
@tusharnain6652 7 месяцев назад
But it's gonna cost WRITE Operations.
@jlbciriaco3142
@jlbciriaco3142 6 месяцев назад
just think about what the user will do more: it will update the data or just see the data? generally is more acceptable a slow write operation than a slow read operation.
@MikdanJey
@MikdanJey Год назад
Great
Далее
Faster Eloquent: Avoid Accessors with Foreach
9:35
Просмотров 52 тыс.
7 Laravel Performance Optimization Tips
2:20
Просмотров 6 тыс.
Eloquent Performance: TOP 3 Mistakes Developers Make
7:59
Speed up MySQL 25-100x with Indexing
7:06
Просмотров 31 тыс.
Optimizing Eloquent: Running Out Of Memory?
6:11
Просмотров 42 тыс.