Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Optimizing Application Design

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


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint