Scaling SQLite to 4M QPS on a Single Server
blog.expensify.com
Scaling SQLite to 4M QPS on a Single Server
1–5 of 5 posts
Re: Scaling SQLite to 4M QPS on a Single Server
#2This is from 2018, but still interesting.
Re: Scaling SQLite to 4M QPS on a Single Server
#3The epilogue mentions meltdown and spectre. I’m no expert on these, but wouldn’t the use case of a self hosted server where you install trusted applications only not be affected by meltdown and spectre?
My understanding was the w biggest worries with those bugs were precisely in the cloud, since they run untrusted code and run multiple users on the same hardware.
Re: Scaling SQLite to 4M QPS on a Single Server
#4> Make RANDOM() deterministic (for some reason it’s non-deterministic by default)
What does making RANDOM() deterministic mean? Seems like it defeats the purpose of generating randomness.
Re: Scaling SQLite to 4M QPS on a Single Server
#5> Make RANDOM() deterministic (for some reason it’s non-deterministic by default) What does making RANDOM() deterministic mean? Seems like it defeats the purpose of generating randomness.
I assume that is for the benchmark to have accurate results and not for normal operation.