What is better? To have a big number of tables with not to much data or small number of tables with a lot of data? 10x MYSQL!
Check out this article:
http://www.phpbuilder.com/columns/barry20000731.php3