How to implement the activity stream in a social network
Summary: For about 1 million active users and 150 million stored activities, I keep it simple: Use a relational database for storage of unique activities (1 record per activity / “thing that happened”) Make the records as compact as you can. Structure so that you can quickly grab a batch of activities by activity ID … Read more