issue_comments: 1294306071

Quick crude benchmark: ```python import sqlite3

db = sqlite3.connect(":memory:")

def create_table(db, name): db.execute(f"create table {name} (id integer primary key, title text)")

create_table(db, "single") create_table(db, "multi") create_table(db, "bulk")

def insert_singles(titles): inserted = [] for title in titles: cursor = db.execute(f"insert into single (title) values (?)", [title]) inserted.append((cursor.lastrowid, title)) return inserted

def insert_many(titles): db.executemany(f"insert into multi (title) values (?)", ((t,) for t in titles))

def insert_bulk(titles): db.execute("insert into bulk (title) values {}".format( ", ".join("(?)" for _ in titles) ), titles)

titles = ["title {}".format(i) for i in range(1, 10001)] Then in iPython I ran these: In [14]: %timeit insert_singles(titles) 23.8 ms ± 535 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

In [13]: %timeit insert_many(titles) 12 ms ± 520 µs per loop (mean ± std. dev. of 7 runs, 100 loops each)

In [12]: %timeit insert_bulk(titles) 2.59 ms ± 25 µs per loop (mean ± std. dev. of 7 runs, 100 loops each) ``` So the bulk insert really is a lot faster - 3ms compared to 24ms for single inserts, so ~8x faster.