Skip to content

Instantly share code, notes, and snippets.

@sargun
Created April 14, 2016 08:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sargun/7503ba636c1a0eb2e2f5cda7a6a23db2 to your computer and use it in GitHub Desktop.
Save sargun/7503ba636c1a0eb2e2f5cda7a6a23db2 to your computer and use it in GitHub Desktop.
100 - 50000 INSERTs into table with no index...................... 0.069s
110 - 50000 ordered INSERTS with one index/PK..................... 0.106s
120 - 50000 unordered INSERTS with one index/PK................... 0.116s
130 - 25 SELECTS, numeric BETWEEN, unindexed...................... 0.093s
140 - 10 SELECTS, LIKE, unindexed................................. 0.096s
142 - 10 SELECTS w/ORDER BY, unindexed............................ 0.099s
145 - 10 SELECTS w/ORDER BY and LIMIT, unindexed.................. 0.101s
150 - CREATE INDEX five times..................................... 0.193s
160 - 10000 SELECTS, numeric BETWEEN, indexed..................... 0.093s
161 - 10000 SELECTS, numeric BETWEEN, PK.......................... 0.080s
170 - 10000 SELECTS, text BETWEEN, indexed........................ 0.120s
180 - 50000 INSERTS with three indexes............................ 0.154s
190 - DELETE and REFILL one table................................. 0.164s
200 - VACUUM...................................................... 0.161s
210 - ALTER TABLE ADD COLUMN, and query........................... 0.004s
230 - 10000 UPDATES, numeric BETWEEN, indexed..................... 0.109s
240 - 50000 UPDATES of individual rows............................ 0.113s
250 - One big UPDATE of the whole 50000-row table................. 0.031s
260 - Query added column after filling............................ 0.012s
270 - 10000 DELETEs, numeric BETWEEN, indexed..................... 0.143s
280 - 50000 DELETEs of individual rows............................ 0.149s
290 - Refill two 50000-row tables using REPLACE................... 0.322s
300 - Refill a 50000-row table using (b&1)==(a&1)................. 0.155s
310 - 10000 four-ways joins....................................... 0.261s
320 - subquery in result set......................................
0.432s
980 - PRAGMA integrity_check...................................... 0.296s
990 - ANALYZE..................................................... 0.045s
TOTAL....................................................... 3.717s
100 - 50000 INSERTs into table with no index...................... 0.496s
110 - 50000 ordered INSERTS with one index/PK..................... 0.445s
120 - 50000 unordered INSERTS with one index/PK................... 0.434s
130 - 25 SELECTS, numeric BETWEEN, unindexed...................... 0.090s
140 - 10 SELECTS, LIKE, unindexed................................. 0.097s
142 - 10 SELECTS w/ORDER BY, unindexed............................ 0.093s
145 - 10 SELECTS w/ORDER BY and LIMIT, unindexed.................. 0.096s
150 - CREATE INDEX five times..................................... 0.981s
160 - 10000 SELECTS, numeric BETWEEN, indexed..................... 0.079s
161 - 10000 SELECTS, numeric BETWEEN, PK.......................... 0.084s
170 - 10000 SELECTS, text BETWEEN, indexed........................ 0.124s
180 - 50000 INSERTS with three indexes............................ 0.807s
190 - DELETE and REFILL one table................................. 0.774s
200 - VACUUM...................................................... 7.996s
210 - ALTER TABLE ADD COLUMN, and query........................... 0.030s
230 - 10000 UPDATES, numeric BETWEEN, indexed..................... 1.043s
240 - 50000 UPDATES of individual rows............................ 1.184s
250 - One big UPDATE of the whole 50000-row table................. 1.073s
260 - Query added column after filling............................ 0.011s
270 - 10000 DELETEs, numeric BETWEEN, indexed..................... 1.866s
280 - 50000 DELETEs of individual rows............................ 1.853s
290 - Refill two 50000-row tables using REPLACE................... 3.510s
300 - Refill a 50000-row table using (b&1)==(a&1)................. 1.330s
310 - 10000 four-ways joins....................................... 0.277s
320 - subquery in result set...................................... 0.479s
980 - PRAGMA integrity_check...................................... 0.310s
990 - ANALYZE..................................................... 0.047s
TOTAL....................................................... 25.609s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment