aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/benchmarks/mysql_benchmark.rb
blob: 2f9e0e6999ddba249b37e4196eec6a9722468d8b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
require 'mysql'

conn = Mysql::real_connect("localhost", "root", "", "basecamp")

require 'benchmark'

require 'profile' if ARGV[1] == "profile"
RUNS = ARGV[0].to_i

runtime = Benchmark::measure {
  RUNS.times { 
    result = conn.query("SELECT * FROM posts LIMIT 100")
    result.each_hash { |p| p["title"] }
  }
}

puts "Runs: #{RUNS}"
puts "Avg. runtime: #{runtime.real / RUNS}"
puts "Requests/second: #{RUNS / runtime.real}"