Thursday, December 29, 2011

Database Development

I've been doing a little work with SQL recently, and I've been trying to figure out the best way to develop somewhat of a "Social Networking" database using as few fields and as small of data as I can. I've run into sort of a problem while doing this. I cannot figure out how I would be able to expand the database if this little project took off. Say I start out great, expecting roughly 2,000 users, and I'm very comfortable with that, but lets say that it expands to 200,000 users. My queries would become exponentially slower, and I would have no idea what to do from there.

9 comments:

  1. I want to know the necessary precautions to take in order to be able to handle that situation.

    ReplyDelete
  2. Good luck, seems like a very hard task to do.

    ReplyDelete
  3. Good luck with all that. Linux servers are always best.

    ReplyDelete
  4. Right, I have a Linux box that's ready for use, but I don't have the bandwidth to support it. And yes, it is a very difficult task. I have a massive white-board filled with the tables and fields.

    ReplyDelete
  5. Best of luck to you and happy new years!

    ReplyDelete
  6. Interns. Social Network. I've seen this movie before...

    ReplyDelete
  7. Best of luck with it man, if you ever get it up and running I'll try it out

    ReplyDelete
  8. I expect it up and running in the next year... Long-shot, yes. The whole "social network" thing is just a base, but it's not a social network website. It's just what I'm using for the design of the user accounts.

    ReplyDelete