Sqlitex Stored Statement vs Query

write_many_bench.ex

defmodule WriteManyBench do
  use Benchfella

  bench "write many with query" do
   {:ok, db} = Sqlitex.open(":memory:")
   Sqlitex.query(db, "CREATE table x(a INTEGER PRIMARY KEY, b);")
   Enum.map 1..1000, fn (i) ->
     Sqlitex.query(db, "INSERT INTO x (b) VALUES (?1);", bind: [i])
   end
  end

  bench "write many with prepared statement" do
    {:ok, db} = Sqlitex.open(":memory:")
    Sqlitex.query(db, "CREATE table x(a INTEGER PRIMARY KEY, b);")
    statement = Sqlitex.Statement.prepare!(db, "INSERT INTO x (b) VALUES (?1);")
    Enum.map 1..1000, fn (i) ->
      Sqlitex.Statement.bind_values!(statement, [i])
      |> Sqlitex.Statement.fetch_all
    end
  end
end