How I Made a 21-Second Query Run in 0.07 Seconds
Database Star
???? Get the SQL Performance Checklist: https://databasestar.mykajabi.com/lpkj-performance-checklist/?video=DJ4UBSOod1k
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/zPYFUthD/checkout?video=DJ4UBSOod1k
In this video, I explain a query I found that originally ran in 21 seconds and how I improved it to run in 0.07 seconds, which is a 300x improvement. I explain the process I followed and the change I made.
TIMESTAMPS:
00:00 - The starting point
03:29 - Understanding the query
06:39 - The root cause
08:26 - The fix
10:05 - Why this is happening
11:20 - The process
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/zPYFUthD/checkout?video=DJ4UBSOod1k
In this video, I explain a query I found that originally ran in 21 seconds and how I improved it to run in 0.07 seconds, which is a 300x improvement. I explain the process I followed and the change I made.
TIMESTAMPS:
00:00 - The starting point
03:29 - Understanding the query
06:39 - The root cause
08:26 - The fix
10:05 - Why this is happening
11:20 - The process
0 Comments
No comments yet. Be the first to weigh in.