I always wonder a large website like facebook, how will they design their database? I mean, a user can have many friends, this is easy to do with just a few users, but with millions of user, it's like SELECT something FROM friendstable WHERE userID=.... from billions of records of, is there a better way to design the table?
Question
maxsquared
I always wonder a large website like facebook, how will they design their database? I mean, a user can have many friends, this is easy to do with just a few users, but with millions of user, it's like SELECT something FROM friendstable WHERE userID=.... from billions of records of, is there a better way to design the table?
Thanks.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts