[wp-hackers] multiple databases vs different database prefixes

Stephen Rider wp-hackers at striderweb.com
Fri Aug 20 00:13:55 UTC 2010

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.


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? 

More information about the wp-hackers mailing list