7 ODBC Application Tuning

You can tune an ODBC application to run optimally on a TimesTen database.

See TimesTen Database Performance Tuning in Oracle TimesTen In-Memory Database Operations Guide for more general tuning tips.

This chapter includes the following topics:

• Avoid Generic Driver Managers If Possible

• Use Arrays of Parameters for Batch Execution

• Avoid Excessive Binds

• Avoid SQLGetData

• Avoid Data Type Conversions

• Bulk Fetch Rows of TimesTen Data

• Optimize Queries