Chapter 2. Optimizing Application Design
In this chapter, we will optimize the application design, introducing various kinds of issues and hints to improve an application's performance. We will present the following recipes:
- Optimizing connection management
- Improving performance by sharing reusable code
- Reducing the number of requests to the database using stored procedures
- Reducing the number of requests to the database using sequences
- Reducing the number of requests to the database using materialized views
- Optimizing performance with schema denormalization
- Avoiding dynamic SQL
Introduction
It is very difficult to change the application design once the development process begins.
Often the primary aim of a software and data architect is to make things ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
