A lot depends on how hard you flex your database. If you're doing complex
queries, stored procedures, triggers and such, I'd put SQL on the faster
machine. Web serving is fairly I/O intensive, but not extremely processor
intensive unless you're doing some serious calculations in your templates.
What is definite is that the SQL server will want more memory. The more you
give it, the better it will perform.
Overall, web apps are not horribly processor intensive. If you have plenty
of memory, and fast disk systems (Ultra-Wide SCSI with hardware RAID 5
controllers that have lots of cache), it will perform quite well, even with
older, slower processors.
Michael J. Sheldon
Internet Applications Developer
Phone: 480.699.1084
http://www.desertraven.com/
PGP Key Available on Request
-----Original Message-----
From: Joy Bedell [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 08, 2000 20:31
To: [EMAIL PROTECTED]
Subject: What goes on the faster machine?
We are finally making the move from Access to SQL Server. Right now we
have both Access and ColdFusion running on the same machine. However, with
our upgrade we are going to put SQL Server on one machine and ColdFusion on
another. My question is, which one should go on the faster machine, CF or
SQL Server?
Any other advice anyone would care to offer would be appreciated. Thanks.
Joy
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
