Thanks guys for all your advice!
-----Original Message-----
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 12:35
To: CF-Server
Subject: RE: Hmmmm?
Kola,
>
> Guys i'm a bit confused here am going to have to tell my boss to
> buy another
> box?
>
> So what is the consensus here that SQL server should be on seperate box or
> it can be on the
> same box as CF as long as the machine has plenty of ram and a fast
> processor?
>
I suppose a summary is :
If your system is going to require a heavy amount of database access or you
need greater security for your data, then potentially you will need to set
up an enterprise system. this could be anthing from IIS/CF Server and a SQL
Server to Multiple IIS Servers -> Firewall Server -> CF Server -> SQL Server
or any combination thereof.
If you don't need to put your database behind a firewall or the load is
light, then you can put IIS/CF/SQL on one box. _BUT_ SQL Server is not the
lightest application in the world and neither are IIS and CF, so you will :
a) need to make sure you have sufficient processing power and memory in the
one server to be able to cope with the load
and b) someone who can administer SQL Server to make sure that it doesn't
suck the life out of the server (hold all the resources memory/cpu for its
own use and not allow anything else access to it)
There is no "better" about either solution. Its "horses for course", take
the solution that best meets _your_ resourses and requirements. In both
cases you _need_ to look at the performance tuning of all the server
applications and the server(s) themselves.
Regards
Stephen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
