Testing relational databases
Almost every application you interact with over the Internet is backed by a database of some sort. Databases house the data needed by the application. Such data is then retrieved and converted to a form required by the graphical user interface (GUI) by a middleware to display to the end user. Depending on the application needs and business logic, some data may be created, updated, and deleted from the database.
Sometimes, it is necessary to directly test databases outside the application(s) that use it. This may help identify database bottlenecks such as expensive table joins, missing table indexes, slow running queries, and so on.
How to do it…
In this recipe, we will cover how JMeter can be used to test a relational database directly. Perform the following steps:
Note
This recipe requires the use of a relational database, so we will set one up here. However, this will most likely have been set up for you, but we do this for illustrative purposes.
Set up an H2 database...
