Skip to content

Instantly share code, notes, and snippets.

@jcalvert
Created December 16, 2011 17:52
Show Gist options
  • Save jcalvert/1487117 to your computer and use it in GitHub Desktop.
Save jcalvert/1487117 to your computer and use it in GitHub Desktop.
ARJDBC Postgres perf changes
ruby-1.9.2-p290 :001 > u = User.last.name
=> "Jon Calvert"
ruby-1.9.2-p290 :002 > require 'benchmark'
=> nil
ruby-1.9.2-p290 :003 > Benchmark.bm do | x|
ruby-1.9.2-p290 :004 > x.report do
ruby-1.9.2-p290 :005 > 1000.times do
ruby-1.9.2-p290 :006 > u = User.last.name
ruby-1.9.2-p290 :007?> end
ruby-1.9.2-p290 :008?> end
ruby-1.9.2-p290 :009?> end
user system total real
1.080000 0.160000 1.240000 ( 33.021254)
=> true
ruby-1.9.2-p290 :010 > Benchmark.bm do | x|
ruby-1.9.2-p290 :011 > x.report do
ruby-1.9.2-p290 :012 > 1000.times do
ruby-1.9.2-p290 :013 > u = User.last.name
ruby-1.9.2-p290 :014?> end
ruby-1.9.2-p290 :015?> end
ruby-1.9.2-p290 :016?> end
user system total real
1.060000 0.160000 1.220000 ( 33.670949)
=> true
jcalvert$ rails c
*** Using highline effectively in JRuby requires manually installing the ffi-ncurses gem.
*** jruby -S gem install ffi-ncurses
Using ActiveModel validations.
Loading development environment (Rails 3.0.9)
/Users/jcalvert/.rvm/rubies/jruby-1.6.5/lib/ruby/1.9/irb/input-method.rb:108 warning: Ignoring internal encoding UTF-8: it is identical to external encoding UTF-8
/Users/jcalvert/.rvm/rubies/jruby-1.6.5/lib/ruby/1.9/irb/input-method.rb:109 warning: Ignoring internal encoding UTF-8: it is identical to external encoding UTF-8
jruby-1.6.5 :001 > require 'benchmark'
=> nil
jruby-1.6.5 :002 > Benchmark.bm do |r|
jruby-1.6.5 :003 > r.report do
jruby-1.6.5 :004 > User.last.email
jruby-1.6.5 :005?> end
jruby-1.6.5 :006?> end
user system total real
0.735000 0.000000 0.735000 ( 0.734000)
=> true
jruby-1.6.5 :007 >
=> true
jruby-1.6.5 :007 >
jruby-1.6.5 :003 > Benchmark.bm do | x|
jruby-1.6.5 :004 > x.report do
jruby-1.6.5 :005 > 1000.times do
jruby-1.6.5 :006 > u = User.last
jruby-1.6.5 :007?> end
jruby-1.6.5 :008?> end
jruby-1.6.5 :009?> end
user system total real
36.938000 0.000000 36.938000 ( 36.938000)
=> true
jruby-1.6.5 :010 > Benchmark.bm do | x|
jruby-1.6.5 :011 > x.report do
jruby-1.6.5 :012 > 1000.times do
jruby-1.6.5 :013 > u = User.last.name
jruby-1.6.5 :014?> end
jruby-1.6.5 :015?> end
jruby-1.6.5 :016?> end
user system total real
39.170000 0.000000 39.170000 ( 39.170000)
=> true
jcalvert$ rails c
*** Using highline effectively in JRuby requires manually installing the ffi-ncurses gem.
*** jruby -S gem install ffi-ncurses
Using ActiveModel validations.
Loading development environment (Rails 3.0.9)
/Users/jcalvert/.rvm/rubies/jruby-1.6.5/lib/ruby/1.9/irb/input-method.rb:108 warning: Ignoring internal encoding UTF-8: it is identical to external encoding UTF-8
/Users/jcalvert/.rvm/rubies/jruby-1.6.5/lib/ruby/1.9/irb/input-method.rb:109 warning: Ignoring internal encoding UTF-8: it is identical to external encoding UTF-8
jruby-1.6.5 :001 > require 'benchmark'
=> nil
jruby-1.6.5 :002 > Benchmark.bm do |r|
jruby-1.6.5 :003 > r.report do
jruby-1.6.5 :004 > User.last.email
jruby-1.6.5 :005?> end
jruby-1.6.5 :006?> end
user system total real
6.857000 0.000000 6.857000 ( 6.856000)
=> true
jruby-1.6.5 :007 >
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment