Re:15k inserts/s with Rust and SQLite (2021)
by zhte415 on Monday April 03, 2023 @12:53AM
(#35418692)
I think it's useful stress testing for when your product goes viral.
For example, if the whole world wanted to create an account, and an account consisted of a UUID and a date, it'd take 5.4 days using this metric as a minimum viable benchmark.
While this is a tongue in cheek comment, it has a valid foundation: 15,000 seems like a large number, and 1 second seems like a small amount of time. On the other hand, 5.4 days seems like quite a large number. Likewise at small scales, 15,000/second operated at a fidelity only able to capture 0.0005% of a typical processor's clock.
It's all about context.
This is not to say that the ability to casually write 15,000 things a second to a database is not impressive in itself.
For example, if the whole world wanted to create an account, and an account consisted of a UUID and a date, it'd take 5.4 days using this metric as a minimum viable benchmark.
While this is a tongue in cheek comment, it has a valid foundation: 15,000 seems like a large number, and 1 second seems like a small amount of time. On the other hand, 5.4 days seems like quite a large number. Likewise at small scales, 15,000/second operated at a fidelity only able to capture 0.0005% of a typical processor's clock.
It's all about context.
This is not to say that the ability to casually write 15,000 things a second to a database is not impressive in itself.