WildFly Performance Tuning

Tuning JPA and Hibernate

Programming with the JDBC API is quite simple as it is merely a thin layer over the database programming interfaces. There are, however, some considerations that you need to take into account:

• First, using the native SQL language in your code exposes your application to a tight coupling with the database where your code had initially been developed. Even if the SQL dialects are similar, each database performs differently depending on the structure of the query, necessitating vendor-specific tuning in most cases.
• Second, when you are using plain JDBC, you need to bridge the gap between the relational model and the object model by creating a layer of intermediate objects or collections that host the data fetched from the database. ...