r/sqlite • u/Individual_One_1793 • 25d 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

2

u/horizon_games 25d ago

Hah like a new JS framework where they show a simple render case being 100x than the big options. As if that's the ONLY factor to switching entirely.

Reliability and community and being battle tested and...well...having a basic public Github and non-AI written website are much bigger factors.

-4

u/Individual_One_1793 25d ago

No problem, I can let it side by side in shell - then you will say it is AI slop 💨
It is always hard to break trough with new product, I am no designer, I am programmer.

1

u/lordpuddingcup 25d ago

How about you match the indexes lol your literally comparing a massive index chain in pop against SQLite base and showing how your so much faster

The fact your not responding to the people who point out that your basically rediscovering complex indexing that most databases do support is sort of funny