aboutsummaryrefslogtreecommitdiff
path: root/test.py
diff options
context:
space:
mode:
authorAnthony Wang2023-10-23 14:01:09 -0400
committerAnthony Wang2023-10-23 14:02:05 -0400
commit63f04f004110ecabfb5ec32408e77055a62a9122 (patch)
tree0c598312cdc91833328e232db8fdc6edd0cee68a /test.py
parent1f36fa09fa178cd8e7d6ba3ce346abe6faa838b1 (diff)
Recommend using WAL for 100% better performance
Diffstat (limited to 'test.py')
-rw-r--r--test.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/test.py b/test.py
index 821bf62..451b403 100644
--- a/test.py
+++ b/test.py
@@ -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):