Posted by Erland Sommarskog on 12/19/06 08:25

Erik Lautier (lautier@gmail.com) writes:
> Thanks Erland...what if the message board and blog were to sit in
> subdomains - is that a stronger argument for using a different
> database? My concern is that if the traffic builds, I wouldn't want
> activity in one area to slow down other areas of the site; but I don't
> want to sacrifice simplicity either. From the sound of it, there's no
> hard and fast rule about this...I'm just trying to plan in the event I
> get the traffic going. Easier to fix now than later. :)

Subdomains? You mean like blogs.lautier.com, messageboard.lautier.com etc?
I can't see that that has anything to do with it.

If you are nervous that the bloggers would slow down the message board,
then the same or the different database does not matter, as long as they
are on the same server. And that would be an argument for different
databases: if you go for different databases from the start, it will be
simple to move the databases between servers.

But then the databases would be entirely independent. Things like storing
users and their profiles should probably be in a separate database, and
the middle tier would be responsible to pass that information to the
databases.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]