diff options
author | Anthony Wang | 2023-10-23 14:01:09 -0400 |
---|---|---|
committer | Anthony Wang | 2023-10-23 14:02:05 -0400 |
commit | 63f04f004110ecabfb5ec32408e77055a62a9122 (patch) | |
tree | 0c598312cdc91833328e232db8fdc6edd0cee68a /test.py | |
parent | 1f36fa09fa178cd8e7d6ba3ce346abe6faa838b1 (diff) |
Recommend using WAL for 100% better performance
Diffstat (limited to 'test.py')
-rw-r--r-- | test.py | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -1,6 +1,7 @@ import sqlite3 con = sqlite3.connect("test.db") +con.execute("PRAGMA journal_mode=wal") cur = con.cursor() cur.execute("CREATE TABLE IF NOT EXISTS cards (idx INTEGER PRIMARY KEY, weight INTEGER, key STRING, val STRING)") for i in range(10**8): |