I Tried to Query 10 MILLION Rows in MySQL in 3 Seconds

Показать описание

I've got a query I want to run on about 10 million rows of data in MySQL. It's slow and I want to get it to run in under 3 seconds.

In this video, I'll show you the query, the current run time, and all the steps I take to try to get it to run in under 3 seconds.

⏱ TIMESTAMPS:
00:00 - The data set
03:33 - The query
05:49 - Add indexes
07:25 - Adjust subquery
08:39 - Another table
11:56 - Joins
15:09 - Adjust table
16:20 - Another approach
18:11 - Ask a question
21:41 - What we learned

🔗 VIDEO LINKS:

COMMANDS:
Replace backslashes:

Рекомендации по теме

Комментарии

You did a great justice on this topic. I'm so impressed at how you made a daunting task seem easy. You're simply the best.

christopherokonkwo

Excellent! I really like how you brought in the stakeholders and provided them with options each with their pros and cons. And thank you for warning people about when DISTINCT is acceptable and when not. Too often I've seen inexperienced people find they're getting back duplicates and just throw in DISTINCT without actually taking the time to figure out where the duplicates are coming from.

JeffreyCogswell

That was amazing... your explanations are clear and concise. Talent and ability to communicate, makes you a great mentor.

MaikolHernandez-kvvl

I've been looking for this long. You are the best!

pattana_pu

Wow this is helpful. Please bring more of these. Thank you

jitxhere

Great example of how just creating indexes doesn't always works. I just learned about indexing today and thought they were an all powerful tool. Glad that I found your video! Thanks

prashastjaipurkar

Wow, what an excellent video, I would personally say one of your best and seriously informative 👍👍👍

PeteSimpson

Can you make the same for Postgresql? with 100 Million rows?

forbidden_lion

I Tried to Query 10 MILLION Rows in MySQL in 3 Seconds

I Tried to Query 10 MILLION Rows in MySQL in 3 Seconds

I Tried to Query 10 MILLION Rows in Postgres in 1 Second

10 Power Query tips EVERY user should know! | Excel Off The Grid

'Query On ChatGPT Requires 8-10x More Power Than Google': Hitachi Energy's N Venu

Power Query - Avoid 'Helper Queries' (+10 Cool Tricks)

Auto Repair - SQL Interview Query 10 | SQL Problem Level 'HARD'

Learn React Query In 50 Minutes

10 awesome Power Query tricks you NEED to know! | Excel Off The Grid

SQL Query Mastery Essential: Filtering, Sorting, and Logical Operators Made Simple

10 MongoDB Queries - Query Embedded Documents

Power Query Replaces XLOOKUP?!

The Fastest Replace Values method using a list in Power Query

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

All I Want for Christmas Is You

Learn SQL: Query 10: Functions SUM() GROUP BY

How to Create a Dashboard in Google Sheets (10 steps) - Query Formula

Remove Outliers - SQL Interview Query 11 | SQL Problem Level 'MEDIUM'

Excel: Split & Group Data with Power Query

I try new year 2025 viral lifehack 🤯 #experiment #5minutscraft #shorts

STOP Struggling with Power Query Auto-Complete and Try This Instead!

Student Result Generator SQL Interview Query - 30 | #30DaySQLQueryChallenge

Power Query - How to return to the Query Editor

3. Kusto Query Language | KQL | Beginner Series | where | take | pipes

Spring Data JPA Query By Example: Write 10x Less Code for Dynamic Searches