From 9f316d8e6ea52518316dec0a320d51c8a866446e Mon Sep 17 00:00:00 2001 From: Anthony Wang Date: Tue, 30 May 2023 14:49:38 -0500 Subject: Add testing script that generates deck DB with 10**8 cards Starting SDC with this DB takes 5 seconds to load all the weights from disk (it's 1.9GB), but after that it's incredibly fast and responsive. Yay segment trees and overengineering! --- test.py | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 test.py diff --git a/test.py b/test.py new file mode 100644 index 0000000..821bf62 --- /dev/null +++ b/test.py @@ -0,0 +1,8 @@ +import sqlite3 + +con = sqlite3.connect("test.db") +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): + cur.execute("INSERT INTO cards VALUES(?, ?, ?, ?)", (i, 1, i, i)) +con.commit() -- cgit v1.2.3-70-g09d2