Mysql Index Tutorial | Make websites 100 Times Faster!!! Query time from 2 Sec to 3 Milli Seconds

[@jamesdube7597]

Thanks, brought my query from 40 seconds to 200 ms on a table with 12 million entries

[@amosherron]

This video helped me take a query from 25 seconds to 0 seconds! Thank you!

[@webdbase]

The query has been cached...

[@jitxhere]

How to do cache query? Using redis??

[@alex-sd]

Excellent explanation on this topic. Thanks so much!

[@ashutoshdwivedi3976]

Can you please share the .sql file for practice? Thanks in advance

[@KerbadouGhazali]

Thanks a lot for this tutorial, you helped me a lot.

[@TechnoTrax]

You're welcome!

[@artemisaix]

What are the guidlines for desinging index on a table.? I mean for example, how many columns can I index, what are the best kind of columns to add an index, what are the NEVER DO on index g design? If someone have info about that I'll appreciate

[@banganirikifidele2432]

Exactly, This is the solution of what I was looking for

[@emekatimothyiloba699]

Nice Explanation

[@ranvijaymehta]

Wow now i became expert also

[@theyoogle]

Its good, please make a tutorial on mysql cpu/ram configuration

[@luciano_mdc7443]

Which is your editor or client?

[@bhumit070]

Will this still work if we use LIKE operator for querying data

[@NikGamer1793]

Thanks mate, was avoiding to learn this as couldn't find such simple example. 😁✌

[@nareshbisht7620]

Bro this is a quality video thanks you. you should make more video.

[@thangws7064]

Your video is so great. Can you post the .sql file on because i want to practice this. Thanks so much ❤️

[@hirinux413]

Good explanation!

[@mariemmatri8743]

Great video, Thanks a lot !!

[@zedlineuz]

very useful video, thank you!

[@bekaarcontent6482]

Perfect Explaining Thanks Dude !

[@georgetsamis6318]

Really great and simple video

[@chintanpatel2229]

Life saver video.

[@papsirhty5812]

Hi sir sorry hope you can help me i want to apply this tutorial on my simple website to speed up the result everytime i hit search button. Ive already add index. I mean its working using mysql but not working in my website ? But when i drop the table the button is working again. Thank u God bless

[@singarimahalaxmi6835]

FOR EX. MY TABLE SIZE IS 300GB THEN INDEXES ARE WORKING FING OR ANY ALTERNATE WAY IS THERE IN MYSQL? PLZ SUGGEST ME

[@falentinodjoka6732]

I've tried your tutorial, but it does not give me an effect. I don't know why, but maybe cause my table only contain 2035 rows data, so i can't feel the effect of index. Can I get that table please? I wanna try it on my localhost.

[@maksat607]

How about indexing date column?

[@pctechcomputers513]

hi. we are getting an FATAL error when we update any data. Can you please help.

[@Rahulverma-zt3sx]

Thank you so much

[@pradnyakasar614]

I got this error (Error Code: 1071. Specified key was too long; max key length is 3072 bytes)

[@shericeross3241]

PERFECT!!

[@ahmedhelal174]

Thank you

[@johnsailor3590]

Those queries are running with MySQL cache…. Those aren’t the correct results.

[@Laravelcode]

this is not valid way to index to any varchar

[@MdRakib-rc6ub]

I need a simple script. Search query from 100 million rows faster way? Budget $50

[@nguyenlu5713]

Make partition and index

[@codemelife]

❤❤

[@tioadjie5361]

Thank you query faster

[@KornYellow]

หัวจัย

[@anurajms]

thank you