The explanation for “What if we can combine sharding by TweetID and Tweet creation time” is very poor.

Reg the API definition of tweet

I think some sections are misplaced in this problem.

Clarification on bits required for TweetID

To handle this, a more intelligent LB solution can be placed that periodically q...

Trying to understand data sharding.If data is sharded by tweetid, we can fetch t...

Benefits of putting creation time in the PK are questionable, since timeline is ...

"Let’s say each tweet has 140 characters and we need two bytes to store a charac...

How many total tweet-views will our system generate? shouldnt this be 200M DAU *...

In Instagram or Twitter design, why does the user follow table use PK as both fo...