I got some more good news from our DataStage team about the changes I made to the ODBC driver. Someone who had a job that was running at about 75 rows per second before my change now is running at 200 rows per second. It seems that simply enabling connection pooling for the ODBC driver gave us about a 25% increase in speed. You gotta love that.

Popular posts from this blog

Using Snapshot Isolation with SQL Server and Hibernate

FreeNAS, CIFS, and user login problems

Official Pandora Desktop and Hotkey Support?