3 ms·
There's a lot of finer details that influence how you design system. Yeah reading data is just SELECT, but there's too many things to consider. - Volume of rea
by darth_avocado 2y ago
There's a lot of finer details that influence how you design system. Yeah reading data is just SELECT, but there's too many things to consider.
- Volume of reads: how many people are reading tweets?
- Volume of tweets: how many unique tweets are being served to people?
- Data skew: Elon's tweets see hundreds of millions of reads, vs some tweets only see like 10.
- Size of data: A tweet looks like only a few characters of data, but every tweet has probably hundreds of columns of metadata.
These are just a few considerations. Plus, scaling out replicas isn't always the feasible after a point. Otherwise, why not just spin up 1 server per tweet and keep things simple.