In answer to your question, the number of tables in the MySQL database will not make it slow.
MySQL handles large databases. The MySQL company know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
- A table cannot contain more than 1000 columns.
- Up to 32 indexes per table are allowed. Each index may consist of 1 to 16 columns or parts of columns.
- MySQL Version 3.22 had a 4 GB (4 gigabyte) limit on table size. With the MyISAM table type in MySQL Version 3.23, the maximum table size was pushed up to 8 million terabytes (2 ^ 63 bytes). Note, however, that operating systems have their own file-size limits.
- By default, MySQL tables have a maximum size of about 4 GB. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name.