Hacker News Reader

Seeing latency figures measured in hundreds of milliseconds in the best cases really drives home for me how big of a deal solutions like SQLite can be.

If you took their exact same hardware and put the application+SQLite on the same box, you could literally chop 4 zeroes off these p99 latency figures. NVMe storage is unbelievably fast when it's utilized in the same machine that the application runs on.

View on HN

That's fine if you don't super care about the data. I expect these latency figures in particular would look better if there wasn't any replication (Q/s might not change much though, would be my guess).

> At PlanetScale, we give you a primary and two replicas spread across 3 availability zones (AZs) by default. Multi-AZ configurations are critical to have a highly-available database. The replicas can also be used to handle significant read load.

Don't even need SQLite for the speed up, although SQLite is fast. I routinely get blazing fast p99 latency on local hardware from postgres itself.

Reply on news.ycombinator.com