[wp-hackers] multiple databases vs different database prefixes

[Paul]

Ken,

I thought I read somewhere that wordpress.com uses the same basic multisite engine and database setup as you mentioned. Other than having redundant and beefier hardware I thing the architecture scales pretty well. 

P-


On Aug 15, 2010, at 6:24 PM, Mike Schinkel wrote:

> 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
> 
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers