Recently i came across with a Open Source software (WPMU Plugin) which makes 3 tables for each user. Now when I asked about this the Forum, the moderator replied:

"It really isn't that hard to believe since the plugin is creating 3 tables for every user when WPMU creates 8 tables for every single blog right now. It makes perfect sense from a scaling point of view because there are already solutions to split the information from WPMU across multiple databases and something in the works for scaling Plugin information as well.

...50,000 users information in a couple of tables is not the best solution. I would rather have those 50,000 users spread across 4000 databases so that you are scanning for 12.5 users per database."

As far as I know.. having millions of tables are never good. As I have more than one million users in my table and if I am going to setup this software, it will create more than 3 million tables..

Now.. what you guys think about their claims?

Regards

[edited by: tedster at 8:30 pm (utc) on Jan. 31, 2009]
[edit reason] shorten the quote [/edit]