diff options
| author | eunhhu <[email protected]> | 2026-09-30 07:56:49 +0100 |
|---|---|---|
| committer | eunhhu <[email protected]> | 2026-09-30 07:56:49 +0100 |
| commit | d98f80dde3052acae503c589e15b5243afb864b7 (patch) | |
| tree | df69d313a582fab5265e1a65fa522aa9924cecb5 /README.md | |
| parent | 0a57c3ad03df6da7eb0a72059bd85c4d716dbb8a (diff) | |
| download | pure-d98f80dde3052acae503c589e15b5243afb864b7.tar.gz pure-d98f80dde3052acae503c589e15b5243afb864b7.zip | |
Compare TPC-C on the SD card with SQLite committing in groups, not each transaction
The 90x of 092 was against SQLite's defaults committing each
transaction; tuned for the card and grouped as Pure groups, SQLite is
4-11x behind, the bytes it writes a transaction being the difference.
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 8 |
1 files changed, 5 insertions, 3 deletions
@@ -17,9 +17,11 @@ their own (`aup query`), verified when registered and shown from snapshots. Fold fold in a table's column is answered for every row from one pass over its list, so on pgbench's tables of 100,000 accounts a group-by, a join and a correlated rank run 3–420x faster than on SQLite, and faster than SQLite given a DBA's indexes but for one count, with no index declared. TPC-C's five transactions, written as one aup app, leave -SQLite's state row for row from the same inputs, and run 4x faster than SQLite in RAM (39,977 against 9,529 a -second, HTTP and JSON included) and 90x faster on an SD card (4,502 against 50), both syncing each commit -([092](docs/research/092-tpcc.md)). Measurements against axum and drogon on a Raspberry Pi 5 +SQLite's state row for row from the same inputs, with one warehouse or four, and run 3.2–3.5x faster than a tuned +SQLite in RAM (36,567 against 10,357 a second, HTTP and JSON included) and 4–11x faster on an SD card than SQLite +tuned for the card and committing in groups as Pure does, both answering once the commit is on the device: SQLite +writes whole pages, 8–18x the bytes a transaction ([092](docs/research/092-tpcc.md), +[106](docs/research/106-tpcc-conditions-first.md)). Measurements against axum and drogon on a Raspberry Pi 5 are in [075](docs/research/075-http-host-against-axum.md), [077](docs/research/077-apps-as-http-services.md), [080](docs/research/080-snapshot-reads.md), [081](docs/research/081-tail-records.md), [082](docs/research/082-json-in-place.md), [083](docs/research/083-delivery-over-http.md), |
