Skip to Content
Java Performance Tuning, 2nd Edition
book

Java Performance Tuning, 2nd Edition

by Jack Shirazi
January 2003
Intermediate to advanced
588 pages
18h 3m
English
O'Reilly Media, Inc.
Content preview from Java Performance Tuning, 2nd Edition

Chapter 16. Tuning JDBC

JDBC (Java Database Connectivity) consists of a set of APIs and specifications that allow any Java application to connect to any JDBC-enabled data repository that executes SQL statements. Usually, this data repository is a relational database (since that is what JDBC was designed for), but the JDBC protocol does not restrict connections to relational databases.

Connecting to a database with JDBC is essential for many applications. This chapter shows you how to identify the bottlenecks in your communications with the database and how to improve the performance of those communications.

The chapter is divided into two sections. The first section, Section 16.1, provides extensive details on building a tool that allows you to determine whether your JDBC communications cause bottlenecks and, if so, which JDBC statements are to blame. If you have already identified JDBC bottlenecks in your application, you can skip this first section. Note that an open source tool, P6Spy (http://www.provision6.com/index.htm), helps identify JDBC bottlenecks by using a similar methodology.

The second section, Section 16.2, provides details on how to tune the JDBC portion of your application. In addition to JDBC-specific issues, this section addresses tuning SQL (Structured Query Language) usage, since optimizing SQL can result in a huge gain in JDBC performance.

Measuring JDBC Performance

As with all other types of tuning, the first step to tuning JDBC usage is to identify bottlenecks. ...

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

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Java Performance Tuning

Java Performance Tuning

Jack Shirazi
Java 9 High Performance

Java 9 High Performance

Mayur Ramgir, Nick Samoylov
Java Servlet Programming, 2nd Edition

Java Servlet Programming, 2nd Edition

Jason Hunter, William Crawford

Publisher Resources

ISBN: 0596003773Errata Page