One Database, How many Tables Allowed?

[ashary]

Is there a limit to how many tables does mySQL allow for every database? Will performance be affected with many tables that runs to about 400 tables?

[HalfaBee]

I don't think there is any limitation to the number of tables in a DB.
It shouldn't affect the performace as each table is just 3 flat files.

Have a look at www.mysql.com for more info

HalfaBee