speedtest1 benchmark reveals performance and correctness issues #1

Open
opened 2026-09-03 00:28:38 +00:00 by jay · 0 comments

Ran a benchmark against SQLite using github.com/sqlite/sqlite@e6082d077e/test/speedtest1.c

Results:

  • Load/indexed reads (100–180): SQLite 49 times faster
  • Mutations/maintenance (190–300): SQLite 47 times faster
  • Four-way joins (310): SQLite ~360,000 times faster
  • Correlated subquery (320): SQLite 7.7 times faster
  • Primary-key workloads (400–520): SQLite 15 times faster
  • Integrity check (980): gsqlite fails
  • Analyze (990): SQLite 66 times faster

https://git.cons.io/jay/gerbil-sqlite/src/branch/benchmarks/benchmarks/Makefile (requires https://github.com/sharkdp/hyperfine)

Ran a benchmark against SQLite using https://github.com/sqlite/sqlite/blob/e6082d077e7e96c91fa366219ae07a1c5ab0ce70/test/speedtest1.c Results: - Load/indexed reads (`100–180`): SQLite 49 times faster - Mutations/maintenance (`190–300`): SQLite 47 times faster - Four-way joins (`310`): SQLite ~360,000 times faster - Correlated subquery (`320`): SQLite 7.7 times faster - Primary-key workloads (`400–520`): SQLite 15 times faster - Integrity check (`980`): gsqlite fails - Analyze (`990`): SQLite 66 times faster https://git.cons.io/jay/gerbil-sqlite/src/branch/benchmarks/benchmarks/Makefile (requires https://github.com/sharkdp/hyperfine)
Sign in to join this conversation.
No labels
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
ober/gerbil-sqlite#1
No description provided.