I’m new to mySQL and am looking into creating a database driven website using it. I intend to have a number of different groups of data and was wondering what is the best way to store this data - either:
- 1 big database with many tables (a table for each group of data)
or - Many separate databases for each group of data?
Which is best for ease-of-management and for faster loading? Are there any limitations to the size of a database or the amount of tables that can be included in each?
Can you provide some examples of some well-known database driven sites and how they would group their data?
Thank you very much in advance for your help
