Mothra1988
kiwifarms.net
- Joined
- May 27, 2021
I've never worked on a system as large as Twitter, but if she has actually blocked two million accounts, that would take up tens if not hundreds of megabytes worth of Database space, and storing that data would impact both price cost and speed. But I have never seen Twitter's database schema, so hopefully it's a table with only two columns in it (UserID and BlockedUserID). I've never tried to write anything for larger than 1000 people, so there maybe be database optimization techniques that I don't know.
TL;DR - Blocklists could potentially expand the database size exponentially if the database schema is written terribly.
Wow she takes up as much space in the Twitter database as she takes up on Earth with her disgusting obesity.