N. America: 800 876 3101 | World: 44 (0) 1753 218 930
 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
Designing Performance - Optimized ODBC Applications
Introduction
Developing performance-oriented ODBC applications is not easy. 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.
This white paper contains some general guidelines that have been compiled by examining the ODBC implementations of numerous shipping ODBC applications. These guidelines include:
- Use Catalog Functions Appropriately
- Retrieve Only Required Data
- Select Functions that Optimize Performance
- Manage Connections and Updates
- Conclusion
Following these general rules will help you solve some common ODBC performance problems, such as those listed in the following table.
| Problem | Solution | Reference Section |
|---|---|---|
| Network communication is slow | Reduce network traffic | Using Catalog Functions |
| Evaluation of complex SQL queries on the database server is slow and can reduce concurrency | Simplify queries | Using Catalog Functions and Selecting ODBC Functions |
| Excessive calls from the application to the driver slow performance | Optimize application-to-driver interaction | Retrieving Data and Selecting ODBC Functions |
| Disk input/output is slow | Limit disk input/output | Managing Connections and Updates |
| Ready to try DataDirect Connect for ODBC? | ||
 |
| | Learn More |
Ready to try DataDirect Connect for ODBC?
