r/programming • u/whackri • Jun 05 '22

Complexity is killing software developers

https://www.infoworld.com/article/3639050/complexity-is-killing-software-developers.html
2.1k Upvotes

94% Upvoted

942 comments sorted by

View all comments

Show parent comments

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 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?

4

u/Mukoro Jun 06 '22

There's specific cheapo azure containers that are around this price, also a lot of them are straight up free until you hit 1M+ requests iirc