Test SQL queries

SQL queries can range from simple to complex. Depending on the nature and importance of your queries, there are two types of query benchmark testing available to you.

Representational SQL benchmarks

This type of testing requires that you test a selection of statements that are representative of typical transactions that the application performs during day-to-day operations. Different applications require different benchmark tests because the fundamental business use for each application varies. For example, a meter reading application might simply test a basic INSERT statement. However a mobile sales force application might test multiple INSERT statements, in addition to multiple SELECT statements and perhaps an UPDATE statement.

The volume of queries in your application can limit what you can realistically test. If you have excessive query processing, you may be limited to performing the targeted SQL benchmark testing.

Targeted SQL benchmarks

If you have a lot of statements used by your applications, you may want to narrow the scope of your test to include some or all of the following:

The most frequently-used statements.
The statements that process high volumes of data.
The statements that have time-sensitive requirements.
The statements that are most important to the business case of your application.
The most complex statements: for example, those that have the largest number of table joins or that use many subqueries. These types of statements can use a large amount of device resources. Even if the statements are only used infrequently, you may want to check that they don't exceed the capacity of the device.
The statements that are not supported by an index.
The statements that use a large amount of memory resources.

Discuss this page in DocCommentXchange.