aboutsummaryrefslogtreecommitdiffstats
path: root/README.md
diff options
context:
space:
mode:
authoreunhhu <[email protected]>2026-09-30 07:56:49 +0100
committereunhhu <[email protected]>2026-09-30 07:56:49 +0100
commitd98f80dde3052acae503c589e15b5243afb864b7 (patch)
treedf69d313a582fab5265e1a65fa522aa9924cecb5 /README.md
parent0a57c3ad03df6da7eb0a72059bd85c4d716dbb8a (diff)
downloadpure-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.md8
1 files changed, 5 insertions, 3 deletions
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),