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

Performance testing - SQL Tutorial

From the course: SQL for Testers

Start my 1-month free trial

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…

Contents