mysql social networking database design

[deepucando]

Hi

i am trying to design a social networking site for my project.

i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut.

can anyone help me to implement the database design with fast and accuracy retrieval of data from the database using the Index and Hash table techniques

regards
~Deepu~

[gunnarflax]

I'm pretty sure this topic doesn't belong in the php forum.

[metalix]

well it is probably being done in php
how big is this SNS going to be?
be careful not to put heavy load on the mysql server.
you could probably use xml files for this.
check my post on your other post for a basic sql layout though. and add a friends column, where you can use an explode() to get all the friends usernames