From the course: SQL for Testers
Join today to access over 25,300 courses taught by industry experts.
Performance testing - SQL Tutorial
From the course: SQL for Testers
Performance testing
- [Instructor] In the toy application that we've been playing with, performance is measured in milliseconds, but out there in that scary place called production, there can be vast amounts of data and huge databases. I've seen queries where runtime is measured in minutes or even hours when dealing with tables that have millions of rows of data. Obviously, in cases like that, the performance becomes important, but how does one go about testing the performance of a SQL query? In general, this is a pretty specialized field that goes beyond what we can cover in this course, but here are a few tips to consider as you think about this. One thing to consider is the context that you're in. If you're dealing with production databases, you don't want to be causing slowdowns that could affect your clients. Be careful about the context in which you do performance testing. You might remember that earlier in the course, we learned about the order of execution. This is the part where that becomes…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.