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 Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/ 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? Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/#findComment-354042 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? Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/#findComment-354947 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 Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/#findComment-354982 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. Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/#findComment-355020 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! Link to comment https://forums.phpfreaks.com/topic/70260-solved-myspace/#findComment-355026 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.