mysql rails benchmarks

gistfile1.txt

C:\dev\ruby\old\ruby-benchmark-suite\benchmarks\rails>ruby -r ..\..\utils\fake_bench.rb bm_substruct_request_root.rb
database appears initialized
Warming up once
  GET /
9705 ms, 1 requests, 0 req/sec

Benchmarking 1x

   .
18 ms, 1 requests, 55 req/sec
90
Warming up once
  GET /
17 ms, 1 requests, 58 req/sec

Benchmarking 90x

   .......... .......... .......... .......... .......... ..........
   .......... .......... ..........
1830 ms, 90 requests, 49 req/sec
1.85203504562378
#<Benchmark::Tms:0x3dd9ae0 @label="", @real=1.85303592681885, @cstime=0.0, @cutime=0.0, @stime=0.125, @utime=1.248, @total=1.373>

So you'll see 1.85s real, 1.2s user.  Assume the rest was in the DB.  

I could be wrong, though--look below to see that the DB was taking more than the rendering.  So my benchmark might be flawed.

gistfile2.txt

example log from the same run:

Processing ContentNodesController#show_by_name (for 127.0.0.1 at 2010-06-21 13:09:55) [GET]
  Parameters: {"name"=>"home"}
Rendering template within layouts/main
Rendering content_nodes/show_by_name
Completed in 10ms (View: 2, DB: 5) | 200 OK [http://www.example.com/]


Processing ContentNodesController#show_by_name (for 127.0.0.1 at 2010-06-21 13:09:55) [GET]
  Parameters: {"name"=>"home"}
Rendering template within layouts/main
Rendering content_nodes/show_by_name
Completed in 9ms (View: 3, DB: 5) | 200 OK [http://www.example.com/]


Processing ContentNodesController#show_by_name (for 127.0.0.1 at 2010-06-21 13:09:55) [GET]
  Parameters: {"name"=>"home"}
Rendering template within layouts/main
Rendering content_nodes/show_by_name
Completed in 9ms (View: 3, DB: 3) | 200 OK [http://www.example.com/]


Processing ContentNodesController#show_by_name (for 127.0.0.1 at 2010-06-21 13:09:55) [GET]
  Parameters: {"name"=>"home"}
Rendering template within layouts/main
Rendering content_nodes/show_by_name
Completed in 9ms (View: 3, DB: 4) | 200 OK [http://www.example.com/]