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 for maximum concurrency and data consistency
Isolation levels determine the level of locking that is required to execute a statement and the level of concurrency that is possible in your application. You need to choose isolation levels for your application that maximize concurrency and that also ensure data consistency.
Disable cursor hold behavior for more efficient resource use
DB2 ODBC can more efficiently use resources that are associated with statement handles if you disable cursor-hold behavior for statements that do not require it.
Code ODBC functions for efficient data retrieval
You can retrieve data more efficiently by following several guidelines.
Limit the use of catalog functions
You can improve performance and reduce lock contention by limiting the use of catalog functions.
Enabling dynamic SQL statement caching for ODBC function calls
To reduce the overhead for function calls, you can prepare a statement once and execute it repeatedly throughout the application.
Turn off statement scanning
To increase performance, you can configure DB2 ODBC to scan for vendor escape clauses only on handles that have escape clauses.

Parent topic: ODBC programming hints and tips