← Orrery · head to head

Against
SQLite

sql.js is SQLite compiled to WebAssembly: a row store with twenty-five years of work behind it. Same rows, same queries, same tab, same clock.

It wins several of these outright, and the ones it wins are the interesting ones. A columnar, vectorized engine should beat a row store on analytical scans and lose to a B-tree on point lookups — showing that tradeoff is worth more than winning everywhere.

I

The run

both engines, one thread

rows runs per query

loading both engines…

II

Results

Fig. 1 Minimum of N runs after a warm-up. Every result is compared between the two engines before its timing is believed — a benchmark that is faster because it computed something else is not a benchmark.

III

What the numbers mean

← Back to Orrery Source →