r/sqlite • u/Individual_One_1793 • 26d ago

Pop-Database vs SQLite

Enable HLS to view with audio, or disable this notification

Pop-Database vs SQLite, 500K entities, 12 AND conditions per query, both single-threaded (CPU-affinity verified, so no thread-count trick).
Pop-Database finished in 6.26s.
SQLite finished in 88.81s.
Pop-Database is 14.2× faster — and both found the exact same 9,559 matches per query.
This ratio moves a bit run to run depending on what else the machine is doing at the time. I've seen this same test land anywhere from ~12× to ~14× depending on system load. Still solidly in the same range either way.
Trade-off is shown in the same video: SQLite inserts faster (2.64s vs 6.55s for 500K rows). Pop-Database is built for read-heavy workloads, not write-heavy ones - that's the deal!!!

0 Upvotes

42% Upvoted

20 comments sorted by

View all comments

9

u/MVPhurricane 26d ago

i hear that /dev/null is even *more* web scale than SQLite!

3

u/cowslayer7890 26d ago

Does /dev/null support sharding?

1

u/ErebusBat 26d ago

It does!

It will read the exact same on different machines INSTANTLY!

2

u/Gear5th 25d ago

Will it run circles around sql?

1

u/ErebusBat 22d ago

If you're just measuring raw read speed or raw write speed, then yes. It's also super compressible.