Book

Chapter 1 “Performance Isn’t What It Used to Be

Describes the evolution of database middleware and identifies where performance bottlenecks can appear.

Chapter 2 “Designing for Performance: What’s Your Strategy?”

Provides guidelines for designing your database application and tuning the database middleware that connects your application to the database server for optimal performance.

Chapter 3 “Database Middleware: Why It’s Important”

Explains what database middleware is, what it does, and how it affects performance. It also describes what you should look for in a database driver, one of the most important components of database middleware.

Chapter 4 “The Environment: Tuning for Performance”

Describes the different environment layers that data requests and responses flow through, explains how they affect performance, and provides guidelines for making sure the environment does not become a performance bottleneck.

Chapter 5 “ODBC Applications: Writing Good Code”

Describes some good coding practices that can provide optimal performance for your ODBC applications.

Chapter 6 “JDBC Applications: Writing Good Code”

Describes some good coding practices that can provide optimal performance for your JDBC applications.

Chapter 7 “.NET Applications: Writing Good Code”

Describes some good coding practices that can provide optimal performance for .NET applications.

Chapter 8 “Connection Pooling and Statement Pooling”

Provides details about different connection pool models, describes how reauthentication works with connection pooling, and tells how using statement pooling with connection pooling might consume more memory on the database server than you realize.

Chapter 9 “Developing Good Benchmarks”

Provides some basic guidelines for writing benchmarks that many developers don’t follow but absolutely should.

Chapter 10 “Troubleshooting Performance Issues”

Walks you through how to troubleshoot performance issues and provides case studies to help you think through some varied performance issues and figure out how to resolve them.

Chapter 11 “Data Access in Service Oriented Architecture (SOA) Environments”

Provides some general guidelines to make sure that your database applications perform well in SOA environments.

Glossary