Developing performance-oriented ODBC applications requires iteration and perseverance. You must be willing to change your application and test it to see if your changes helped performance. Microsoft’s ODBC Programmer’s Reference does not provide information about system performance. In addition, ODBC drivers and the ODBC Driver Manager do not return warnings when applications run inefficiently.
Some general guidelines for developing performance-oriented ODBC applications include:
Use catalog functions appropriately.