Chapter 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% of performance problems can be traced back to the application.

Designing Applications for Relational Access

Application design ...

Get Database Administration: The Complete Guide to Practices and Procedures now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.