[wp-hackers] multiple databases vs different database prefixes

[Stephen Rider]

If you do decide to run 300 separate WP installs, you might take a look at this:  http://striderweb.com/nerdaphernalia/features/virtual-multiblog/

It will make actual file maintenance much easier.

Steve

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

> 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?