why do you like to complicate things >_< get a better host than can handle huge database and save yourself all the hassle.
Is that possible to create or plugin for one username and able to login to all my sub wp installation ???
Reason : i have a huge site and really need to split it to few DB (installation) but worry user need to do different login for each individual wp installation .
currently i running 2 dedicated for one single wordpress (hyper DB), custom Sphinx Search Index and i still facing some issue ....
basically wordpress (standard) is not welcome HUGE db site due to their internal core program
I do try a lot alternative but it work that well.... don't ask me why i must go with wordpress not drupal or joomla, answer is pretty obvious, i run almost three similar content(rewrite) site ..... but at the end, wordpress bring me more then 10x organic traffic then joomla or drupal
You need custom code rather than blogging software IMO. Ranking and traffic is not due to the WP core engine, but what is rendered to the page after all the plugins did their work, and what you did to build links etc. It's almost cruel what you are doing to these poor servers
I try custom code but most coder just deliver site for Human but not good for bot , when come to custom features they will quotes me sky high prices but in wordpress i can get it for free/low cost, also i know how to implement it without 100% depend on coder