On Fri, Apr 8, 2011 at 8:27 AM, Jason Allen <[email protected]> wrote: > How would you think that busy sites like facebook and myspace manage > each users' friends list? With the sites having millions if not > hundreds of millions of users, and some users have thousands of > friends, one giant table with all friend connections seems like a bad > idea.
My first question is, do you expect to have that level of data to deal with? Only reason I ask is because the decisions Facebook, Twitter, etc. make and how they architect things are based on a very, very, very rarefied level of traffic and data storage that 99.999999% of applications will never have to deal with. So let's start there. :-) -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
