High Performance JDBC
Vlad is a software architect, passionate about enterprise systems, high scalability and all sorts of concurrency challenges. He has a gold badge on StackOverflow for Hibernate and Java and his blog features a Hibernate tutorial section with over 60 articles. He is currently writing the High-Performance Java Persistence book.
JDBC has been around for a long time but because the database interaction happens through higher abstraction API (such as JPA/Hibernate or jOOQ), it’s easy to forget that the actual communication plays by the database driver and the database engine rules. This presentation goes through the most common sources of performance bottlenecks: database connection management, batch updates, statement caching, result set fetching and concurrency control mechanisms with practical references for the most common database systems: Oracle, SQL Server, PostgreSQL and MySQL.