TechTalk: Improve ODBC Performance

DB2
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

You can significantly speed up your Open Database Connectivity (ODBC) database access if you are using the Wall Data ODBC driver by selecting the option to cache statistics locally. This can be done when you sign on to a data source by clicking on the Options button. Put a check in the Cache Statistics Locally box and specify a number of days for the refresh interval (see 1).

You can significantly speed up your Open Database Connectivity (ODBC) database access if you are using the Wall Data ODBC driver by selecting the option to cache statistics locally. This can be done when you sign on to a data source by clicking on the Options button. Put a check in the Cache Statistics Locally box and specify a number of days for the refresh interval (see Figure 1).

Every time ODBC connects to a data source or reads a file, it gathers information about the data source or file. This can take a long time. Storing the statistics locally will allow the ODBC driver to keep the information on the local PC, reducing the communication overhead and host processing time.

The refresh interval is useful if your database changes. The Wall Data driver will refresh the statistics to be sure the information stored locally correctly reflects the current database layout. The database layout will not change often unless you are doing development work and changing the layout of files frequently. For most production software, the layout shouldn't change unless you upgrade to a new version.

- Brian Singleton

TechTalk: Improve ODBC Performance

Figure 1: ODBC Data Source Settings


BLOG COMMENTS POWERED BY DISQUS