Created
April 14, 2016 08:16
-
-
Save sargun/7503ba636c1a0eb2e2f5cda7a6a23db2 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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