I'm setting up a wordpress site where each user will need to have their own blog. My thought was it's the perfect use case of Wordpress Multisite. I've setup it with multisite using Sub-directory and everything works great.
But the problem I'm facing is with the numbers of tables in the database. Currently for each blog additional 12 tables are created which might increase a few more. So, if there is 1000 users on my site, there will be more than 12000 tables on my Database. It will grow beyond that as the site needs to be scaled for thousands of users.
My question is -
- What is the performance penalty for having thousands of tables?
- Is it going to scale with the growth of users/tables?
- Is multisite the right tool for this job?