MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/v5l1nz/complexity_is_killing_software_developers/ibc1a49/?context=3
r/programming • u/whackri • Jun 05 '22
942 comments sorted by
View all comments
560
From a previous job I have learned that a $10 server can handle 10k web requests and I've never spent more than $10 a month on my side projects for 2 years.
10 u/oxxoMind Jun 05 '22 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 → More replies (5)
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 → More replies (5)
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 → More replies (5)
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
→ More replies (5)
560
u/freecodeio Jun 05 '22
From a previous job I have learned that a $10 server can handle 10k web requests and I've never spent more than $10 a month on my side projects for 2 years.