helpinghand
search
needassistance
 
How To
Spot Performance Bottlenecks in ODBC Applications
Category: ODBC
Introduction

ODBCPERF is a utility that you can use to track where ODBC applications can be optimized. ODBCPERF inserts itself between the ODBC Driver Manager and the real ODBC Driver and samples how much time each ODBC routine takes to execute.

Each ODBC routine call is logged in a log file with information about handles, total time, CPU time. You can then examine the log files to see where calls to ODBC routines take a long time to complete.

Note! The ODBCPERF program described herein should be used with Mimer SQL 8. From Mimer SQL 9.2, a tool called Mimer ODBC Trace is included in the Mimer SQL distributions for Windows which replaces the ODBCPERF program. For details on Mimer ODBC Trace, please refer to the ODBC Trace section in the Mimer SQL Getting Started Guide for Windows.
Environment

The ODBCPERF utility is currently available on Windows platforms.

The odbcperf.zip file contains two files: odbcperf.dll and config.exe. See below how to install and use the package.
Example

Setup procedure:

  1. Download and unpack odbcperf.zip (right-click and do "Save Link Target As...") that contains the performance analysis tool for ODBC. Note! It should be used with Mimer SQL version 8.


  2. Run config.exe.


  3. Specify where odbcperf.dll is located.


  4. Click the ‘Logging...’ button.


  5. Specify where you want the log files to be stored.


  6. Click ‘OK’ to close the dialog box.


  7. Click ‘Add...’ and select an ODBC data source to log.


  8. Select which functions you want to log.


  9. Click ‘Enable’ to enable logging for the data source.


The Uninstall button will remove all changes made by this utility and set everything back to normal.

Log file names are in the form odbcperf-pid-X, where ‘pid’ is the current process id and ‘X’ is a counter to make the log file unique.


Benefits

By profiling your ODBC application using this feature you can see which ODBC calls the application performs and how much time each call takes.

This can be an interesting topic especially for an application generated by a development tool.
Links

General description of the ODBC Interface.

For details on Mimer ODBC Trace in Mimer SQL 9, please refer to the ODBC Trace section in the Mimer SQL Getting Started Guide for Windows.
Last updated: 2005-04-13

 

Powered by Mimer SQL

Powered by Mimer SQL