Toad World® Forums

SQL stability

Hello ,

I didn’t understand we use SQL stability test to test specific SQL statement when more than users working on database or what?



The purpose of the SQL Scalability test is to see how SQL statements perform as the number of users executing that SQL in parallel increase. This will aid the user in finding possible concurrency issues in their SQL. It is also used to compare the above performance for different alternative SQL so that a user may select the best SQL for their application. The SQL statement which executes the fastest as a single user does not always perform the best when executed in parallel.