Contents

# encoding: UTF-8
$LOAD_PATH.unshift File.expand_path(File.dirname(__FILE__) + '/../lib')

require 'rubygems'
require 'benchmark'
require 'active_record'

ActiveRecord::Base.default_timezone = :local
ActiveRecord::Base.time_zone_aware_attributes = true

number_of = 10
mysql2_opts = {
  :adapter => 'mysql2',
  :database => 'test'
}
mysql_opts = {
  :adapter => 'mysql',
  :database => 'test'
}

class Mysql2Model < ActiveRecord::Base
  set_table_name :mysql2_test
end

class MysqlModel < ActiveRecord::Base
  set_table_name :mysql2_test
end

Benchmark.bmbm do |x|
  x.report "Mysql2" do
    Mysql2Model.establish_connection(mysql2_opts)
    number_of.times do
      Mysql2Model.all(:limit => 1000).each{ |r|
        r.attributes.keys.each{ |k|
          r.send(k.to_sym)
        }
      }
    end
  end

  x.report "Mysql" do
    MysqlModel.establish_connection(mysql_opts)
    number_of.times do
      MysqlModel.all(:limit => 1000).each{ |r|
        r.attributes.keys.each{ |k|
          r.send(k.to_sym)
        }
      }
    end
  end
end

Version data entries

50 entries across 50 versions & 6 rubygems

Version	Path
mysql2-0.3.4	benchmark/active_record.rb
mysql2-0.2.9	benchmark/active_record.rb
mysql2-0.3.3	benchmark/active_record.rb
mysql2-0.2.8	benchmark/active_record.rb
rdp-mysql2-0.2.7.1	benchmark/active_record.rb
mysql2-0.3.2	benchmark/active_record.rb
mysql2-0.3.1	benchmark/active_record.rb
mysql2-0.3.0	benchmark/active_record.rb
mysql2-0.2.7	benchmark/active_record.rb
mysql2_bigint-0.2.6.1	benchmark/active_record.rb