Alright. I’m building a site for college students that, although not a social networking site, has some features similar to Facebook.
For those of you who do have a Facebook account and are familiar with the workings of the site, maybe you can help out here. I have a couple of questions, but I thought I’d make this a general thread that anyone can tack questions onto. The answers I’m looking for are how you think the people at Facebook did something, and not so much how you think you would implement the same feature yourself (unless of course, you think there is room for improvement).
[U]My questions:
[/U]1. What’s up with all the sub-domains? Is there a separate database for each network, or is it all one massive db?
- How is it possible to edit the comma-delimited strings? For example, when you type in all of your interests, separated by commas, and post them, I would have to assume that it stores each one as a separate DB entry in an “interests” table with a composite table in between to keep track of which interests belong to you. However, when you go to edit your interests, it puts them all back together in the same comma delimited string you submitted. How can so many records be checked, and then be inserted/updated/deleted all at once without timing out?
