DB Link Optimization Techniques

This chapter describes 4 techniques that can be used to optimize an application when working with an RDBMS.

• Step 1: Executing a Query Multiple Times, shows the proper way to execute a query several times.

• Step 2: Optimizing Network Use, shows how to optimize use of the network.

• Step 3: Accessing Data Directly, shows how to optimize data transfer with the RDBMS.

• Step 4: Keeping Data in Memory, shows how to efficiently keep data read from the RDBMS in memory.