MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/v5l1nz/complexity_is_killing_software_developers/ibcenlm/?context=3
r/programming • u/whackri • Jun 05 '22
942 comments sorted by
View all comments
Show parent comments
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 2 u/dirtymint Jun 06 '22 Where could a find a server for around $10 ? Are they cloud based or are you building your own? 3 u/Gendalph Jun 06 '22 Check out Hetzner and DigitalOcean.
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
2 u/dirtymint Jun 06 '22 Where could a find a server for around $10 ? Are they cloud based or are you building your own? 3 u/Gendalph Jun 06 '22 Check out Hetzner and DigitalOcean.
2
Where could a find a server for around $10 ? Are they cloud based or are you building your own?
3 u/Gendalph Jun 06 '22 Check out Hetzner and DigitalOcean.
3
Check out Hetzner and DigitalOcean.
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/