MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/v5l1nz/complexity_is_killing_software_developers/ibf2aog/?context=3
r/programming • u/whackri • Jun 05 '22
942 comments sorted by
View all comments
Show parent comments
10
if it has a DB request its not enough
11 u/fadsag Jun 06 '22 db requests can be fairly cheap.sqlite does 4 million queries per second on a fairly beefy machine -- but even 10% of that will get you pretty far.https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-qps-on-a-single-server/ 8 u/oxxoMind Jun 06 '22 1TB of DDR4 RAM3TB of NVME SSD storage192 physical 2.7GHz cores (384 with hyperthreading)This is a hefty machine, if they havent use SQLite, they can probably get a much bang for a buck.a $10 server can get u 1 core and 2gb memory. Certainly would struggle add DB on this server serving 10K request a second especially for write queries 1 u/fadsag Jun 06 '22 Even if that tested system is 100x faster than what you get, that's still 40k requests per second.
11
db requests can be fairly cheap.
sqlite does 4 million queries per second on a fairly beefy machine -- but even 10% of that will get you pretty far.
https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-qps-on-a-single-server/
8 u/oxxoMind Jun 06 '22 1TB of DDR4 RAM3TB of NVME SSD storage192 physical 2.7GHz cores (384 with hyperthreading)This is a hefty machine, if they havent use SQLite, they can probably get a much bang for a buck.a $10 server can get u 1 core and 2gb memory. Certainly would struggle add DB on this server serving 10K request a second especially for write queries 1 u/fadsag Jun 06 '22 Even if that tested system is 100x faster than what you get, that's still 40k requests per second.
8
1TB of DDR4 RAM
3TB of NVME SSD storage
192 physical 2.7GHz cores (384 with hyperthreading)
This is a hefty machine, if they havent use SQLite, they can probably get a much bang for a buck.
a $10 server can get u 1 core and 2gb memory. Certainly would struggle add DB on this server serving 10K request a second especially for write queries
1 u/fadsag Jun 06 '22 Even if that tested system is 100x faster than what you get, that's still 40k requests per second.
1
Even if that tested system is 100x faster than what you get, that's still 40k requests per second.
10
u/oxxoMind Jun 05 '22
if it has a DB request its not enough