I would go buy some more memory.
128 and 256 are at the very lower limit for production servers, especially
with NT. I'd leave the 256 in the web server, and bump the DB server to 512.
Otherwise, your assessment on where the load occurs is correct.
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: Sunday, April 09, 2000 07:04
To: [EMAIL PROTECTED]
Subject: RE: What goes on the faster machine?
--=====================_47333350==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
Michael,
Thank you for taking the time to write such a helpful response. Based on
what you said, I think we should put SQL Server on the new machine, but
take 128 megs of memory from the current machine and put it in the new
one. We have only a handful of people who access the website, but we have
some rather large tables that I join together and loop through the results,
grouping and calculating.
NEW MACHINE:
- Dual Pentium MB, PIII 600's
- 128 PC 100 SDRAM
- 8.4 Western Digital Hard drive
- 10\100 Mbps, 3COM PCI NIC
CURRENT MACHINE:
- Dual Pentium MB, PII 300's
- 256 PC 100 SDRAM
- 8.4 Western Digital Hard drive
- 10\100 Mbps, 3COM PCI NIC
I'm not real sure where to draw the line between what gets processed by the
database and what gets processed by ColdFusion. Tell me if I have this
correct: Whatever I put in a CFQUERY will be performed by the the
database; calculations that I put in CFSET will be performed by CF, along
with any other CF processes like CFLOOP and CFOUTPUT. So, if I have
aggregate functions being calculated in a CFQUERY, that's the database
doing it; if I have CFOUTPUT GROUP=fieldname, that's CF doing it. Is this
correct?
Thanks,
Joy
At 10:39 PM 4/8/00 -0700, you wrote:
>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.
--=====================_47333350==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
Michael,<br>
<br>
Thank you for taking the time to write such a helpful response.
Based on what you said, I think we should put SQL Server on the new
machine, but take 128 megs of memory from the current machine and put it
in the new one. We have only a handful of people who access the
website, but we have some rather large tables that I join together and
loop through the results, grouping and calculating.<br>
<br>
NEW MACHINE: <br>
- Dual Pentium MB, PIII 600's <br>
- 128 PC 100 SDRAM <br>
- 8.4 Western Digital Hard drive <br>
- 10\100 Mbps, 3COM PCI NIC <br>
<br>
CURRENT MACHINE: <br>
- Dual Pentium MB, PII 300's <br>
- 256 PC 100 SDRAM <br>
- 8.4 Western Digital Hard drive <br>
- 10\100 Mbps, 3COM PCI NIC <br>
<br>
I'm not real sure where to draw the line between what gets processed by
the database and what gets processed by ColdFusion. Tell me if I
have this correct: Whatever I put in a CFQUERY will be performed by
the the database; calculations that I put in CFSET will be performed by
CF, along with any other CF processes like CFLOOP and
CFOUTPUT. So, if I have aggregate functions being calculated
in a CFQUERY, that's the database doing it; if I have CFOUTPUT
GROUP=fieldname, that's CF doing it. Is this correct?<br>
<br>
Thanks,<br>
<br>
Joy<br>
<br>
At 10:39 PM 4/8/00 -0700, you wrote:<br>
<blockquote type=cite cite>A lot depends on how hard you flex your
database. If you're doing complex<br>
queries, stored procedures, triggers and such, I'd put SQL on the
faster<br>
machine. Web serving is fairly I/O intensive, but not extremely
processor<br>
intensive unless you're doing some serious calculations in your
templates.<br>
<br>
What is definite is that the SQL server will want more memory. The more
you<br>
give it, the better it will perform.<br>
<br>
Overall, web apps are not horribly processor intensive. If you have
plenty<br>
of memory, and fast disk systems (Ultra-Wide SCSI with hardware RAID
5<br>
controllers that have lots of cache), it will perform quite well, even
with<br>
older, slower processors.<br>
<br>
Michael J. Sheldon<br>
Internet Applications Developer<br>
Phone: 480.699.1084<br>
<a href="http://www.desertraven.com/"
eudora="autourl">http://www.desertraven.com/</a><br>
PGP Key Available on Request<br>
<br>
-----Original Message-----<br>
From: Joy Bedell
[<a href="mailto:[EMAIL PROTECTED]"
eudora="autourl">mailto:[EMAIL PROTECTED]</a>]<br>
Sent: Saturday, April 08, 2000 20:31<br>
To: [EMAIL PROTECTED]<br>
Subject: What goes on the faster machine?<br>
<br>
<br>
We are finally making the move from Access to SQL Server. Right now
we<br>
have both Access and ColdFusion running on the same machine.
However, with<br>
our upgrade we are going to put SQL Server on one machine and ColdFusion
on<br>
another. My question is, which one should go on the faster machine,
CF or<br>
SQL Server?<br>
<br>
Any other advice anyone would care to offer would be appreciated.
Thanks.<br>
<br>
Joy<br>
<br>
----------------------------------------------------------------------------
<br>
--<br>
Archives:
<a href="http://www.egroups.com/list/cf-talk"
eudora="autourl">http://www.eGroups.com/list/cf-talk</a><br>
To Unsubscribe visit<br>
<a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk</a>
or<br>
send a message to [EMAIL PROTECTED] with 'unsubscribe'
in<br>
the body.<br>
<br>
----------------------------------------------------------------------------
--<br>
Archives: <a href="http://www.egroups.com/list/cf-talk"
eudora="autourl">http://www.eGroups.com/list/cf-talk</a><br>
To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk"
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&bo
dy=lists/cf_talk</a> or send a message to [EMAIL PROTECTED]
with 'unsubscribe' in the body. </blockquote></html>
--=====================_47333350==_.ALT--
----------------------------------------------------------------------------
--
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.
