From the course: SQL for Testers
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Performance testing
- [Instructor] In the toy application that we've been using in this course, performance is measured in milliseconds, but out there, there's that scary place called production, where there can be vast amounts of data and huge databases. I've seen queries where the runtime is measured in minutes or even hours or days when dealing with tables that have millions of rows of data. So obviously, in cases like this, performance becomes important, but how do you go about testing the performance of a SQL query? In general, that's a pretty specialized field that goes beyond what we can cover in this course. But there are a few tips for you to consider as you think about this. For one thing, when you're querying databases that are used in production, you got to to be careful about slowdowns and that you don't cause any slowdowns that could affect your clients or your customers who are using that. I won't go over how to do timing of…
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.