Techniques for improving application performance
You can follow several techniques to improve your application performance.
To improve the performance of your Db2 ODBC
applications, consider taking the following actions:
- Set isolation levels.
- Disable cursor hold behavior.
- Retrieve result sets efficiently.
- Limit the use of catalog functions.
- Use dynamic statement caching.
- Turn off statement scanning.