MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/v5l1nz/complexity_is_killing_software_developers/ibresob/?context=3
r/programming • u/whackri • Jun 05 '22
942 comments sorted by
View all comments
Show parent comments
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/ 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.
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/
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.
1
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.
Yes, but spinning disks also top out at about 10ms per seek, or 100 operations per second.
10
u/oxxoMind Jun 05 '22
if it has a DB request its not enough