Banchmark SQL

banchmark_sql_query.rb

bm = ->(counter=1) {
  Benchmark.measure do
    counter.times do |i|
      Sponsorship.joins(:sponsor, :orphan).
                  where("sponsor_id = ?",1).
                  select("orphans.name as orphans_name, orphans.date_of_birth as orphans_date_of_birth, orphans.gender as orphans_gender").
                  to_a
      # puts i
    end
  end
}

bm.call(1000)