课程: SQL for Testers

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Performance testing

Performance testing - SQL教程

课程: 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…

内容