Benchmark of #pluck_all

[khiav223577]

Benchmark

def test()
  old_logger = ActiveRecord::Base.logger
  ActiveRecord::Base.logger = nil
  Benchmark.bm(32) do |x|
    x.report('map'){ 
      User.where('').map do |user|
        {
          'account'  => user.account,
          'email'    => user.email,
          'realname' => user.realname,
        }
      end
    }
    x.report('select + map'){ 
      User.select(:account, :email, :realname).map do |user|
        {
          'account'  => user.account,
          'email'    => user.email,
          'realname' => user.realname,
        }
      end
    }
    x.report('select + as_json'){ 
      User.select(:account, :email, :realname).as_json(only: [:account, :email, :realname])
    }
    x.report('pluck_all'){ 
      User.pluck_all(:account, :email, :realname)
    }
  end
  ActiveRecord::Base.logger = old_logger

  nil
end
test()

Benchmark-ips

require 'benchmark/ips'
def test()
  old_logger = ActiveRecord::Base.logger
  ActiveRecord::Base.logger = nil

  Benchmark.ips do |x|
    x.report('map'){ 
      User.limit(100).map do |user|
        {
          'account'  => user.account,
          'email'    => user.email,
          'realname' => user.realname,
        }
      end
    }
    x.report('select + map'){ 
      User.limit(100).select(:account, :email, :realname).map do |user|
        {
          'account'  => user.account,
          'email'    => user.email,
          'realname' => user.realname,
        }
      end
    }
    x.report('select + as_json'){ 
      User.limit(100).select(:account, :email, :realname).as_json(only: [:account, :email, :realname])
    }
    x.report('pluck_all'){ 
      User.limit(100).pluck_all(:account, :email, :realname)
    }
    x.compare!
  end
  ActiveRecord::Base.logger = old_logger

  nil
end
test()

[khiav223577]

compare with pluck_to_hash 1.0.2

Benchmark

def test()
  old_logger = ActiveRecord::Base.logger
  ActiveRecord::Base.logger = nil
  Benchmark.bm(32) do |x|
    x.report('pluck_to_hash'){ 
      User.pluck_to_hash(:account, :email, :realname)
    }
    x.report('pluck_all'){ 
      User.pluck_all(:account, :email, :realname)
    }
  end
  ActiveRecord::Base.logger = old_logger

  nil
end
test()

Benchmark-ips

require 'benchmark/ips'
def test()
  old_logger = ActiveRecord::Base.logger
  ActiveRecord::Base.logger = nil

  Benchmark.ips do |x|
    x.report('pluck_to_hash'){ User.limit(1000).pluck_to_hash(:account, :email, :realname) }
    x.report('pluck_all'){ User.limit(1000).pluck_all(:account, :email, :realname) }
    x.compare!
  end
  ActiveRecord::Base.logger = old_logger

  nil
end
test()