O'Reilly logo

Oracle by Guy Harrison

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

Chapter 6. Application Design and Implementation

In this chapter we look at how to design and implement an application that works efficiently and effectively with the Oracle database server.

Typical optimization efforts focus on tuning SQL statements after the application is built, and we have several chapters devoted to SQL tuning. Overall application design can, however, also make an enormous difference in performance. Poor design can lead to intractable performance issues that can’t always be resolved by tuning individual SQLs.

Here are some of the techniques we explore in this chapter:

• Reducing the volume of requests from the application to the database server. This can be done by eliminating any unnecessary SQL execution requests and ...

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