Contents

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

require 'rubygems'
require 'benchmark'
require 'mysql'
require 'mysql2'
require 'do_mysql'

def run_escape_benchmarks(str, number_of = 1000)
  Benchmark.bmbm do |x|
    mysql = Mysql.new("localhost", "root")
    x.report do
      puts "Mysql #{str.inspect}"
      number_of.times do
        mysql.quote str
      end
    end

    mysql2 = Mysql2::Client.new(:host => "localhost", :username => "root")
    x.report do
      puts "Mysql2 #{str.inspect}"
      number_of.times do
        mysql2.escape str
      end
    end

    do_mysql = DataObjects::Connection.new("mysql://localhost/test")
    x.report do
      puts "do_mysql #{str.inspect}"
      number_of.times do
        do_mysql.quote_string str
      end
    end
  end
end

run_escape_benchmarks "abc'def\"ghi\0jkl%mno"
run_escape_benchmarks "clean string"

Version data entries

12 entries across 12 versions & 2 rubygems

Version	Path
ghazel-mysql2-0.2.6.3	benchmark/escape.rb
ghazel-mysql2-0.2.6.2	benchmark/escape.rb
ghazel-mysql2-0.2.6.1	benchmark/escape.rb
mysql2-0.2.6	benchmark/escape.rb
mysql2-0.2.6-x86-mswin32-60	benchmark/escape.rb
mysql2-0.2.6-x86-mingw32	benchmark/escape.rb
mysql2-0.2.5	benchmark/escape.rb
mysql2-0.2.4	benchmark/escape.rb
mysql2-0.2.3	benchmark/escape.rb
mysql2-0.2.2	benchmark/escape.rb
mysql2-0.2.1	benchmark/escape.rb
mysql2-0.2.0	benchmark/escape.rb