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?