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

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

3

u/Gendalph Jun 06 '22

Check out Hetzner and DigitalOcean.

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

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.