Pastable version of ActiveRecord threaded benchmark

<pre class='prettyprint' language='ruby'>require 'rubygems'
require 'active_record'
require 'benchmark'

ActiveRecord::Base.establish_connection :adapter =&gt; 'sqlite3', :database =&gt; 'perf_ar.db'

# set up ActiveRecord
class ArItem &lt; ActiveRecord::Base
  set_table_name 'items'
end

# created schema and data
class NewItem &lt; ActiveRecord::Migration
  def self.up
    create_table :items do |t|
      t.column :name, :string
      t.column :description, :text
      t.column :active, :boolean
      t.column :created_at, :datetime
    end
  end
  def self.down
    drop_table :items
  end
end
NewItem.up

1000.times do |i|
  ArItem.create(:name =&gt; &quot;record_#{i}&quot;, :description =&gt; &quot;test record&quot;, :active =&gt; i.remainder(3).zero?)
end

# run benchmarks
Benchmark.bmbm do |x|
  
  x.report('active_record single-thread') do
    100.times do
      ArItem.find(:all, :conditions =&gt; [&quot;active = ?&quot;, false])
    end
  end
  
  x.report('active_record threaded') do
    ActiveRecord::Base.allow_concurrency = true
    threads = []
    10.times do
      t = Thread.new do
        10.times do
          ArItem.find(:all, :conditions =&gt; [&quot;active = ?&quot;, false])
        end
      end
      threads.push(t)
    end
    threads.each { |t| t.join }
  end
  
end
ActiveRecord::Base.verify_active_connections!
NewItem.down</pre>
<a href="http://www.refactormycode.com/codes/238-activerecord-threaded-benchmark" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of ActiveRecord threaded benchmark