Book Image

JMeter Cookbook

By : Bayo Erinle
Book Image

JMeter Cookbook

By: Bayo Erinle

Overview of this book

Table of Contents (16 chapters)
JMeter Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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.

  1. Set up an H2 database...