PDA

View Full Version : Managing data on multiple databases


FuZion
04-26-2008, 05:24 AM
Hello,

I'm soon going to have a website processing thousands of data rows a day. The data will be assigned to specific sections of the website, and these sections will be created by users. My question is this: what is the best way to manage the databases from an organizational standpoint? Should I set up multiple databases and use PHP to organize and find the data? If so, how would I do this? I know that I will eventually run out of space in my databases, so how will I migrate to more than one database?

Thank you for your advice!

Fumigator
04-27-2008, 08:03 PM
Properly indexed and normalized and optimized, one database will be sufficient for your needs.