O'Reilly logo

Database Administration: The Complete Guide to DBA Practices and Procedures, Second Edition by Craig S. Mullins

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

12. Application Performance

Now that we have discussed performance from the system and database perspective, it is time to turn our attention to performance from the application code perspective. This chapter focuses on tuning and optimizing the application code and SQL statements, as well as ensuring the application interacts with the DBMS appropriately and efficiently. Poorly constructed and formulated application code accounts for the majority of relational database performance problems—as many as 80 percent of performance problems can be traced back to the application.

Poorly constructed and formulated application code accounts for most relational database performance problems.

Designing Applications for Relational Access

Application design ...

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