From db045dbbf60b53dbe013ef25554fd013baf88134 Mon Sep 17 00:00:00 2001
From: David Heinemeier Hansson <david@loudthinking.com>
Date: Wed, 24 Nov 2004 01:04:44 +0000
Subject: Initial

git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
---
 activerecord/benchmarks/mysql_benchmark.rb | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 activerecord/benchmarks/mysql_benchmark.rb

(limited to 'activerecord/benchmarks/mysql_benchmark.rb')

diff --git a/activerecord/benchmarks/mysql_benchmark.rb b/activerecord/benchmarks/mysql_benchmark.rb
new file mode 100644
index 0000000000..2f9e0e6999
--- /dev/null
+++ b/activerecord/benchmarks/mysql_benchmark.rb
@@ -0,0 +1,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}"
\ No newline at end of file
-- 
cgit v1.2.3