From d98f80dde3052acae503c589e15b5243afb864b7 Mon Sep 17 00:00:00 2001 From: eunhhu Date: Wed, 30 Sep 2026 07:56:49 +0100 Subject: 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. --- README.md | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'README.md') diff --git a/README.md b/README.md index 2826f3d..0d93d9a 100644 --- a/README.md +++ b/README.md @@ -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), -- cgit v1.2.3