Book Image

WildFly Performance Tuning

Book Image

WildFly Performance Tuning

Overview of this book

Table of Contents (17 chapters)
WildFly Performance Tuning
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Tuning the Java Database Connectivity API


Java Database Connectivity (JDBC) is the Java standard that defines how a client accesses a (in most cases, relational) database. The different database vendors provide an implementation of this API, often called a JDBC driver.

Even if the basic purpose of JDBC is to provide a standardized way of executing native SQL statements and handling the result sets, it's often used as a foundation for other frameworks, for example, JPA or Hibernate.

Performance-tuning JDBC consists of the following processes:

  • Introducing a database connection pool that reuses your connections

  • Making use of proper JDBC features, such as fetch size and batch size

  • Using prepared statements in your application and configuring a prepared statement cache at application server level

Connection pooling

The first basic rule you need to follow when programming JDBC is to use a connection pool when accessing a database. Establishing database connections, depending upon the platform, can take...