[wp-hackers] multiple databases vs different database prefixes

[Mike Schinkel]

Ken,

Not sure if my advice on the subject would be relevant (I've never done anything that large) but you might be interested in talking to these guys who are offering a service for managing lots of WordPress installs:

http://www.wpremote.com/

-Mike

On Aug 15, 2010, at 5:48 PM, Ken Zaraque wrote:

> Hello to All, 
> 
> I will be creating numerous WP sites - roughly 300+.  I will not be using the multisite feature. These are 300+ separate WP installations.
> 
> Question: Is it better to create each site with it's own database, or should all 300+ sites be in one database but each site having different table prefixes? 
> 
> My concern is scaling.  I am concerned that running all 300+ sites in one database would slow down performance vs having separate databases. Although, having all tables be in one database is very convenient if I ever need to share information between sites.
> 
> Maybe I can use a combination of both?  
> 
> What are your thoughts? 
> 
> Thanks, 
> 
> Ken
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers