Updated ODBC Application Performance Tutorial

Default Blog Top Image
by Paul Griffin Posted on December 05, 2011

We have added fresh options and content to our ODBC application performance tutorial.   From connection pooling, to packet size, and many other options, each one is explained in detail making the options easy to understand - and making it even easier to optimize application performance with DataDirect Connect for ODBC Drivers!

Do you have the need for speed in your application?  Want to enable bulk load so you can migrate data from one database to another much faster?  It's all in the guide!

One of the advantages of DataDirect Connect® Series ODBC drivers (DataDirect Connect for ODBC and DataDirect Connect64 for ODBC) is their flexibility; they can be fine-tuned to enhance performance. The settings that enhance performance may result in reduced functionality, but often the functionality vs. performance trade-off has no impact on the application. The information in the following sections discusses how to tune the DB2, Informix, Informix Wire Protocol, Oracle, Oracle Wire Protocol, and Sybase Wire Protocol drivers for increased performance.

• Informix (Connect for ODBC only) and Informix Wire Protocol • Oracle Wire Protocol and Oracle Client • Sybase Wire Protocol • DB2 Wire Protocol • SQL Server Wire Protocol • MySQL Wire Protocol • Salesforce Wire Protocol • PostgreSQL Wire Protocol • Greenplum Wire Protocol

Click here to go to the ODBC application performance tutorial


Paul-Griffin
Paul Griffin
View all posts from Paul Griffin on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
More from the author

Related Tags

Prefooter Dots
Subscribe Icon

Latest Stories in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation