[UPHPU] MySQL Limits

[Brandon Stout]

Timothy Humphrey wrote:
> Is it better to have 1000 tables with 1000 records each? or one table
> with 1,000,000 records? how about when it gets to 1,000,000,000 records?

This depends on what you want to do.  Don't have more than one table
that holds the same information, but do have different tables for
related data with a 1-to-many, many-to-1, or many-to-many relationship. 
Normalize up to third normal form.

Brandon Stout
http://mscis.org