[wp-hackers] multiple databases vs different database prefixes

Mike Schinkel mikeschinkel at newclarity.net
Sun Aug 15 22:24:54 UTC 2010


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:



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

More information about the wp-hackers mailing list