Will having 150ish tables in my DB make it slow? If not, how many would, if ever?

And is there a max to tables in a DB, max to columns or rows in tables?

Thanks

Anybody know?

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.

Assume:
- 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.

Wow.

Thanks for the info, that makes me feel so much better.

How do I know the current table size ?