Contents

# frozen_string_literal: true

require 'bundler/inline'

gemfile do
  source 'https://rubygems.org'
  gem 'sqlite3'
  gem 'extralite', path: '..'
  gem 'benchmark-ips'
end

require 'benchmark/ips'
require 'fileutils'

DB_PATH = "/tmp/extralite_sqlite3_perf-#{Time.now.to_i}-#{rand(10000)}.db"
puts "DB_PATH = #{DB_PATH.inspect}"


def prepare_database(count)
  db = Extralite::Database.new(DB_PATH)
  db.query('create table if not exists foo ( a integer primary key, b text )')
  db.query('delete from foo')
  db.query('begin')
  count.times { db.query('insert into foo (b) values (?)', "hello#{rand(1000)}" )}
  db.query('commit')
  db.close
end

def sqlite3_run(count)
  db = SQLite3::Database.new(DB_PATH)
  results = db.execute('select * from foo')
  raise unless results.size == count
end

def extralite_run(count)
  db = Extralite::Database.new(DB_PATH)
  results = db.query_ary('select * from foo')
  raise unless results.size == count
end

[10, 1000, 100000].each do |c|
  puts; puts; puts "Record count: #{c}"

  prepare_database(c)

  Benchmark.ips do |x|
    x.config(:time => 3, :warmup => 1)

    x.report("sqlite3") { sqlite3_run(c) }
    x.report("extralite") { extralite_run(c) }

    x.compare!
  end
end

Version data entries

4 entries across 4 versions & 2 rubygems

Version	Path
extralite-bundle-2.5	test/perf_ary.rb
extralite-2.5	test/perf_ary.rb
extralite-bundle-2.4	test/perf_ary.rb
extralite-2.4	test/perf_ary.rb