I would hope to have 1/100th of that level of traffic. And while it most likely won't, I'd sleep better at night knowing that what could be my busiest recordset is built in a way that could easily scale, and is efficient from the start.
If you had to architect the table structure for a site that would have that kind of traffic, how would you do it? I'm leaning towards one principle table that contains all friends, and if that table grows to a point that I need multiple tables, I will simply duplicate the table, and call it 'table 2'. Then I could simply note in each member's core table which table has their friends so that when I need to lookup the friend's list of a certain member, I just query whichever table has their data. On Fri, Apr 8, 2011 at 10:52 AM, Matthew Woodward <[email protected]>wrote: > 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 > -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
