feGWA6zj

1import time
2import sqlite3
3
4
5def main():
6    conn = sqlite3.connect(':memory:')
7    conn = sqlite3.connect('.db')
8    c = conn.cursor()
9    c.executescript('''
10    pragma synchronous = off;
11    pragma foreign_keys = off;
12    pragma temp_store = memory;
13    pragma journal_mode = memory;
14
15    create table if not exists relation (
16        a text,
17        b text,
18        t date default (datetime('now', 'localtime')),
19        primary key (a, b)
20    );
21    ''')
22
23    t0 = time.time()
24    for i in range(100):
25        for j in range(100):
26            c.execute("insert or ignore into relation(a, b) values(?, ?)", (i, j))
27            conn.commit()
28            c.rowcount == 1
29        t1 = time.time()
30        print(t1 - t0)
31
32
33if __name__ == '__main__':
34    main()