>I have an question about the design of a database. What is the best way >to design tables. Is it better to create many small tables, or create >fewer big tables. Which of those two options will get the best performance?
If you are asking whether to store the data all in one big table or a bunch of smaller identical tables it would be a tradeoff of speed vs. complexity. Normalization can go a long wat to helping. Check out: http://www.vbmysql.com/articles/normalize.html Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]