Wordpress MU tables

I want to move  my community site's member blogs from inhouse code to something like wordpress mu.

From what I can see, Wordpress MU creates 9 MYSQL tables for each separate blog. Given that I have around 6,000 member blogs (and counting), that's an extra 54,000 tables, (an extra 162,000 files in the mysql data directory).

It seems to me that this has the potential to create a maintenance nightmare, as well as having some nasty MySQL efficiency implications.

Am I looking at this the wrong way?  Is WPMU up to handling 5,000 ~ 10,000 blogs?  Is there an alternative?
jashawAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

andrewbleakleyCommented:
I would hold off any decision about Wordpress MU at the moment it is being considered for a merge with Wordpress 3.0

See http://wpmu.org/merging-or-discontinuing-the-future-of-wordpress-mu/ and http://mu.wordpress.org/forums/topic/15744

On the right hosting infrastructure Wordpress MU could easily handle the 10,000 blogs by the way
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gwkgCommented:
I'll take andrew's comment a step further and say that it is being merged into Wordpress 3.0.

The scope of 3.0 has been decided, as of the 1/7/10 dev chat in IRC, which took into account how many people requested various features in this thread. 3.0 will include:

* The merge with MU (but not the extra domain stuff, which will remain plugin territory for this version)
* Better support for custom post types
* New default theme
* Better menu management (time permitting)

Thanks to everyone who weighed in on this thread to help determine the scope of version 3.0!

Source: http://wordpress.org/support/topic/345127/page/7

Screenshots: http://wpengineer.com/wordpress-3-multisite-settings/
0
gwkgCommented:
I should have added that the release is scheduled for May 2010.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
WordPress

From novice to tech pro — start learning today.