Databases Reference
In-Depth Information
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:
F
Optimizing connection management
F
Improving performance by sharing reusable code
F
Reducing the number of requests to the database using stored procedures
F
Reducing the number of requests to the database using sequences
F
Reducing the number of requests to the database using materialized views
F
Optimizing performance with schema denormalization
F
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 work, but designing
applications for optimal performance is not a marginal aspect, many applications need to
meet specific timing requirements to be useful.
In this chapter, we will investigate some aspects to keep in mind when designing an
application and some tips on specific database features, which can help us in this task.
