Chapter 11. Database Performance Best Practices
This chapter investigates the performance of Java-driven database applications. Applications that access a database are subject to non-Java performance issues: if a database is I/O-bound or if it is executing SQL queries that require full table scans because an index is missing, no amount of Java tuning or application coding is going to solve the performance issues. When dealing with database technologies, be prepared to learn (from another source) about how to tune and program the database.
This is not to say that the performance of an application that uses a database is insensitive to things under the control of the JVM and the Java technologies that are used. Rather, for good performance, it is necessary to ensure that both the database and the application are correctly tuned and executing the best possible code.
This chapter starts by looking at JDBC drivers, since those influence the data frameworks that talk to relational databases. Many frameworks abstract the JDBC details, including the JPA and the Spring data modules.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access