Lets say 1 website need 10 database table to work and i want a database pool that 40.000+ website will be inside.
Which option is better for server performance?
1) 400 databases each have 1000 table?
2) 4000 databases each have 100 table?
Update: I see i need to put some more details, sorry for trying to ask simple as much as i can. Site will based on wordpress multisite with http://wordpress.org/extend/plugins/hyperdb/
1 website with 10 database table generally wont pass 6-7 mb as total database info. There will be 9-10 heavy website that will have serious database info, i will put them in a special database. ( lets say 4096 database, 96 reserve for vip,heavy sites and split all other sites in 4000 database )
Server is: http://www.wiredtree.com/managedhybrid/ After reaching some point, i am planning move to pure dedicated server which will based on raid10 15k RPM SAS mysql discs and different media discs
So 40.000 sites but all of them sharing same php files, just different databases and different upload folders. This is how wordpress.com working. Same rules but my sites wont be a blog.
Please ask what other info do you want, i will try to explain more. I am very sorry if i break any rules or something.
( Sorry for bad english too :P )