This post originated from an RSS feed registered with Ruby Buzz by Leon Katsnelson. Original Post: Speeding up the ibm_db2 adapter Feed Title: DB2 on Rails Feed URL: http://db2onrails.com/blog/xml/rss/feed.xml Feed Description: DB2 on Rails is a blog maintained by the IBM team working on DB2 enablement for Ruby on Rails. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Leon Katsnelson Latest Posts From DB2 on Rails

If you would like to speed up the current 1.1 version of the adapter included in the Starter Toolkit for DB2 on Rails, you can replace the ‘tables’ and ‘colums’ methods from within the ibm_db2_adapter.rb file, with this code here.

This change will allow you to significantly boost your performance level when working with Rails and DB2. As you may note, the crucial change here relies on the fact that a slow driver call is replaced with ad hoc query to the SYSCAT.

Naturally this will be included with the next toolkit release, which will be out soon. ;-)