jgaskins

Benchmarking ActiveRecord vs Perpetuity::Postgres

Running through a set of common CRUD operations. Each object on both ORMs uses a single model containing 3 attributes: a String, a Fixnum, and a Time. Each benchmark operates on 5000 objects.

Instantiating 5000 objects

           user     system      total        real
AR     0.230000   0.010000   0.240000 (  0.240430)
PORO 0.000000 0.000000 0.000000 ( 0.001539)

jgaskins

Inserting
              user     system      total        real
Numeric   0.070000   0.010000   0.080000 (  0.586738)
UUID      0.070000   0.020000   0.090000 (  3.101085)

Retrieving by id
              user     system      total        real
Numeric   0.810000   0.980000   1.790000 (  6.831551)
UUID      0.830000   0.990000   1.820000 (  6.981944)

jgaskins

Parsing...
Calculating -------------------------------------
            nokogiri       127 i/100ms
              libxml       130 i/100ms
                  ox       716 i/100ms
-------------------------------------------------
            nokogiri     1334.7 (±15.1%) i/s -       6604 in   5.215835s
              libxml     1287.5 (±1.9%) i/s -       6500 in   5.050367s
                  ox     7228.3 (±3.7%) i/s -      36516 in   5.059256s

jgaskins

module Foo
  class Application < Rails::Application
    # Keep the credit card data out of your logs
    config.filter_parameters += [:password, :credit_card]
  end
end

jgaskins

require 'active_record'
require 'pg'

ActiveRecord::Base.establish_connection host: 'localhost',
                                        database: 'jamie',
                                        adapter: 'postgresql'

class ARModel < ActiveRecord::Base
  def initialize(attributes={})
    # AR::Base#create w/o args passes nil because lol.

jgaskins

# Add these two gems

gem 'thread_safe'
gem 'cache_digests'

jgaskins

require 'benchmark'

def fib n
  if n <= 1
    n
  else
    fib(n - 1) + fib(n - 2)
  end
end

jgaskins

# If it were possible to override && and || in Ruby, this is how it might look.

class NilClass
   def && other
      self
   end
   
   def || other
      other
   end

jgaskins

class Foo
   def initialize: (attributes={}) ->
      # Set default day to Monday
      # This broke for Sunday (attributes.day == 0)
      @day = attributes.day || 1

      # How I ended up doing it
      @day = if attributes.hasOwnProperty('day') then attributes.day else 1

jgaskins

class ArticlesController < ApplicationController
  # with ActiveRecord
  def create
    @article = Article.new(params[:article])
    
    if @article.save
      redirect_to @article, notice: 'Article created!'
    else
      render :new
    end