Portlet Factory, Version 6.1.2

---

 

Optimization of database operations

There are several techniques you can use to optimize your database operations. These include:

• Use a Cache Control builder to store relatively-static results of a query. If the data does not change more frequently than hourly, caching the database action is a good strategy.

• Use settings available in the low-level SQL builders to maximize database efficiency. For example, The SQL Datasource builder provides Timeout settings to manage connection and acquisition of a database. The SQL Statement builder provides ResultSet Performance Hints settings and Execution Throttles that allow you to optimize ResultSet handling and control the amount of data being retrieved.

Parent topic: Working with a database

---

Library | Support |