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?
 
andrewbleakleyConnect With a Mentor Commented:
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
 
gwkgConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.