[wp-hackers] multiple databases vs different database prefixes

[ken zarque]

Thank you again, everyone.

After long talks with the IT team, we decided to go with MS which uses one
large database.

After installing WP with MS turned on, we ran into this question "How do we
deploy single sites in an MS environment from one environment to another".
This is because we have a dev, staging and production environment.

Note: Should I be asking this on a separate thread?


On Thu, Aug 19, 2010 at 5:13 PM, Stephen Rider <wp-hackers at striderweb.com>wrote:

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