O'Reilly logo

The Data Access Handbook: Achieving Optimal Database Application Performance and Scalability by Robert A. Steward, John Goodson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER EIGHT: Connection Pooling and Statement Pooling

In Chapter 2, “Designing for Performance: What’s Your Strategy?,” we defined connection pooling and statement pooling and discussed the performance implications of using these features. But we didn’t go into specifics, such as the different connection pool models, how reauthentication works with connection pooling, and how using statement pooling with connection pooling might consume more memory on the database server than you realize. If you are interested in these details and more, read this chapter. If you haven’t already read the section about these features in Chapter 2, you may want to do that first.

Connection Pool Model for JDBC

A JDBC application can use connection pooling through ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required