Ticket #1423: smartsave-bm.rb

ROOT = File.dirname(__FILE__) + "/.."
$:.unshift "#{ROOT}/activerecord/lib"

require 'active_record'
require 'benchmark'

ActiveRecord::Base.logger = Logger.new(nil)
ActiveRecord::Base.colorize_logging = false

ActiveRecord::Base.establish_connection(
  :adapter => "sqlite3",
  :dbfile  => ":memory:"
)

DATA.read.split(/;/).each do |statement|
  next if statement.strip.blank?
  ActiveRecord::Base.connection.execute statement
end

N = 1000

class Thing < ActiveRecord::Base
  serialize :mixed_bag
end

value = [1, :two, "three", { :four => [5, "six", :seven] },
          %w(eight nine ten eleven twelve thirteen)]

Thing.create :name => "Joshua Jamis Amos Gordon Buck",
             :description => "But soft! What light through yonder window " +
               "breaks? It is the east, and Juliet is the sun!",
             :mixed_bag => value,
             :age => 30

puts "running each test #{N} times"
Benchmark.bm(35) do |reporter|
  reporter.report("find") { N.times { Thing.find(:first) } }
  reporter.report("save_without_changes") { 
    thing = Thing.find(:first)
    N.times { thing.save! } }
  reporter.report("save_with_changes") {
    thing = Thing.find(:first)
    N.times { thing.age += 1; thing.save! } }
  reporter.report("query_integer_field") {
    thing = Thing.find(:first)
    N.times { thing.age } }
  reporter.report("query_string_field") {
    thing = Thing.find(:first)
    N.times { thing.name } }
  reporter.report("query_string_fields") {
    thing = Thing.find(:first)
    N.times { thing.name; thing.description } }
  reporter.report("query_serializable_field") {
    thing = Thing.find(:first)
    N.times { thing.mixed_bag } }
  reporter.report("query_string_field_and_save") {
    thing = Thing.find(:first)
    N.times { thing.name; thing.save! } }
  reporter.report("query_string_fields_and_save") {
    thing = Thing.find(:first)
    N.times { thing.name; thing.description; thing.save! } }
  reporter.report("query_serializable_field_and_save") {
    thing = Thing.find(:first)
    N.times { thing.mixed_bag; thing.save! } }
  reporter.report("assign_string_field_and_save") {
    thing = Thing.find(:first)
    N.times { thing.name = "Harry Potter"; thing.save! } }
  reporter.report("assign_serializable_field_and_save") {
    thing = Thing.find(:first)
    N.times { thing.mixed_bag = value; thing.save! } }
end

__END__
create table things (
  id integer primary key,
  name varchar2(40) not null,
  description varchar2(40) not null,
  mixed_bag text,
  age integer default 0
);