Designing ODBC Applications for Performance Optimization : Using Catalog Functions

Using Catalog Functions
Because catalog functions, such as those listed here, are slow compared to other ODBC functions, their frequent use can impair system performance:
SQLGetTypeInfo is included in this list of expensive ODBC functions because many drivers must query the server to obtain accurate information about which types are supported (for example, to find dynamic types such as user defined types).
Caching Information to Minimize the Use of Catalog Functions
Avoiding Search Patterns
Using a Dummy Query to Determine Table Characteristics

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.