myspace type DB for managing friends
Posted: Mon Aug 14, 2006 1:37 pm
I'm working on a project that will have a similar DB to how myspace manages friends.
I'm trying to determine the best way to build this out, as one user could potentially have hundreds of thousands of friends...
Would it be best to create an ID table that simply holds the UserID and the UserID of the friend? OR would it be best to just use longtext and hold all friends UserIDs in an array for a paticular user?
Any help would be great... thanks!
I'm trying to determine the best way to build this out, as one user could potentially have hundreds of thousands of friends...
Would it be best to create an ID table that simply holds the UserID and the UserID of the friend? OR would it be best to just use longtext and hold all friends UserIDs in an array for a paticular user?
Any help would be great... thanks!