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 ...