jaymc Posted September 22, 2007 Share Posted September 22, 2007 How the hell do myspace deal with the rediculous amount of members they have When they have 176 million+ members, standard normalisation goes out the window... I mean, they cant have a table called members with 176 million lines of members in there! What methods are available when faced with a problem like that. I dont mean what do myspace do, I mean, whats the norm! Things that spring to my mind is having a members database with a table for each letter in the alphabet. So rather than 176 mllion rows of members, in theory, its now 176 / 26. As well as that they could have each of those tables on a different server, to cluster it with an N-Tier approach Any good articles that go beyond standard normalisation and DB/table design or ideas you have or methods you know Really interested to lean about this stuff Quote Link to comment Share on other sites More sharing options...
fenway Posted September 24, 2007 Share Posted September 24, 2007 There have been countless articles posted on how these and other sites design their databases... but why worry about their problems? Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 25, 2007 Author Share Posted September 25, 2007 Education, I like to think big! Have you any examples of these articles? Quote Link to comment Share on other sites More sharing options...
hackerkts Posted September 25, 2007 Share Posted September 25, 2007 I just made a search in the forums and found this, http://www.phpfreaks.com/forums/index.php/topic,136203.0.html Quote Link to comment Share on other sites More sharing options...
fenway Posted September 25, 2007 Share Posted September 25, 2007 Education, I like to think big! Have you any examples of these articles? It's only education if you apply what you learn. Quote Link to comment Share on other sites More sharing options...
jaymc Posted September 25, 2007 Author Share Posted September 25, 2007 The article in there was fantastic, thats exactly what I wanted thanks guys! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.