3 ms·
This entire project took three prompts: In Python create an in-memory SQLite database with 100 tables each with 10 columns. Time how long it takes
by simonw 4y ago
This entire project took three prompts:
In Python create an in-memory SQLite database with 100 tables
each with 10 columns.
Time how long it takes to execute PRAGMA schema_version
against that database 100 times.
Then add another 100 tables and time PRAGMA schema_version 100
times again.
Now run the whole benchmark a second time, but instead of PRAGMA
schema_version time how long it takes to run
hashlib.md5(db.execute(
"select group_concat(sql) from sqlite_master"
).fetchall()[0]).hexdigest() instead
Then:
Plot those benchmark results over time on a chart
Then:
Run the benchmark again in order to draw a better
chart with measurements for every point between 1
and 200 tables