--=====================_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&body=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&body=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.
