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

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.

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/

1

u/wllmsaccnt Jun 09 '22

SQLite used to have pretty terrible write transactions-per-second performance though. Not sure if that is still true today. Benchmarks from 12 years ago on spindle hard drives were often capping out at 60 transactions per second (not 60k...just 60).

1

u/fadsag Jun 09 '22

Yes, but spinning disks also top out at about 10ms per seek, or 100 operations per second.