# mySQL database general question

**URL:** <https://forum.kirupa.com/t/mysql-database-general-question/182197>\
**Category:** programming\
**Created:** [March 16, 2006, 4:46am UTC](https://forum.kirupa.com/t/mysql-database-general-question/182197 "2006-03-16T04:46:27Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hgfl](https://avatars.discourse-cdn.com/v4/letter/h/8e7dd6/32.png) [@hgfl](https://forum.kirupa.com/u/hgfl)\
**Post date:** [March 16, 2006, 4:46am UTC](https://forum.kirupa.com/t/mysql-database-general-question/182197/1 "2006-03-16T04:46:27Z")

</div>

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