All 17 measured cases
All 17 cases were measured; only reproducible gaps are published. The rest are listed with the reason they were excluded.
| Case | A (ms) | B (ms) | CV | Status |
|---|---|---|---|---|
| txn-vs-autocommit | 8.038 | 2221.983 | 0.0% | published |
| exists-vs-in | 805.394 | 6.037 | 2.2% | published |
| groupby-indexed-vs-not | 1.788 | 74.569 | 2.0% | published |
| order-indexed-vs-random | 1.097 | 32.813 | 3.7% | published |
| pk-lookup-vs-scan | 1.017 | 25.861 | 2.1% | published |
| index-vs-scan | 1.138 | 28.762 | 0.0% | published |
| count-star-vs-count-col | 4.352 | 8.112 | 2.1% | published |
| select-star-vs-cols | 4.295 | 2.555 | 4.1% | published |
| wal-vs-delete | 14.253 | 11.063 | 8.2% | published |
| executemany-vs-loop | 15.737 | 19.655 | 2.0% | published |
| python-join-vs-sql-join | 32.103 | 38.133 | 1.2% | published |
| param-vs-literal | 15.102 | 17.245 | 3.2% | published |
| join-vs-subquery | 1.936 | 1.665 | 9.3% | published |
| like-prefix-vs-contains | 13.386 | 15.167 | 3.4% | published |
| row-vs-tuple | 27.690 | 24.569 | 2.4% | published |
| fetchall-vs-iterate | 10.558 | 10.137 | 1.3% | 差 4.2% < 5% |
| update-index-vs-scan | 12.131 | 12.125 | 6.6% | 差 0.0% < 5% |