How Twitter's timeline actually works: the fanout problem

Ask a candidate to design Twitter and most of them start in the wrong place. They draw a tweets table, a follows table, and a query that joins the two, ordered by time. It looks correct, it would even