# MySQL Tables, how many?

**URL:** <https://forum.kirupa.com/t/mysql-tables-how-many/171341>\
**Category:** Uncategorized\
**Created:** [December 4, 2005, 5:10pm UTC](https://forum.kirupa.com/t/mysql-tables-how-many/171341 "2005-12-04T17:10:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![StarXploser](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/starxploser/32/875_2.png) [@StarXploser](https://forum.kirupa.com/u/StarXploser)\
**Post date:** [December 4, 2005, 5:10pm UTC](https://forum.kirupa.com/t/mysql-tables-how-many/171341/1 "2005-12-04T17:10:09Z")

</div>

Hi,  
I need to set up a database that would keep track of people’s information.  
basic stuff like fname lname, age, email etc…  
and also a lot more… overall about 30columns would be needed in my table.  
We are excpecting a large amount of people, so I don’t want things to be slow.

Should i use 1 big table for each user?

or group columns in groups of 5-10 according to their meaning or w/e. ?

which one would be faster?

Thx