I'm using WordPress multisite in which each user will have a separate blog. For each blog, additional 15 tables are created. The website will be used by thousands of users. That means that there will be over 15,000 tables which will grow with each user.
- Is there a performance penalty for having this many tables on a single database?
- How significant it is compared to a single WordPress installation?