Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement