WildFly Performance Tuning

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 ...