Another source for performance tweaking your system is
http://www.regedit.com They have registry tweaks that will greatly improve
system performance. Though I have noticed that this discussion has
completely revolved around hardware. Some the the bigest gains that you will
get out of your application are not tied to your hardware. As for the
hardware, a cluster of inexpensive servers will be the better solution. If
you are going to spend money on equipment, spend it on the database server,
not the web servers.
Also, make sure that you have truely optimized your CF Code. Make sure you
are using contructs like:
CompareNoCase instead of "var is 'whatever'"
Scope all the variables that you can.
Use cfmodule instead of short hand annotation for custom tags
Use cfquery's instead of cfinserts, etc.
Make sure your queries are return only what you need.
Cache queries that seldom change and are universal to all users of the site
(like categories on a shopping site)
Use stored procedures on your database, whenever you can.
I have found that it is the tweaks in your code and not the hardware that
truely makes the most difference in the performance of an application.
That is my 2 cents worth.
Thanks,
David Sparkman
-----Original Message-----
From: Bryan Batchelder [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 2:08 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Milking every last drop of CF performance...
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF734.DFE6BD60
Content-Type: text/plain;
charset="iso-8859-1"
If you wanna really get wacky....make a RAM drive (yes, you can do it in NT
too) and set that to be the swap partition :-)
--b
"A product's only late once, but it can suck
forever." -- Ben Spees, Ambrosia Software
--------------------------------------------
Bryan D. Batchelder
Palm Wireless/Internet Application Developer
W: 813.935.7100
W: 813-936-8844 x 423 (after 5:30PM EST)
H: 727-547-1322
M: 727-808-4296
--------------------------------------------
ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618
--------------------------------------------
-----Original Message-----
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 3:09 PM
To: [EMAIL PROTECTED]
Subject: RE: Milking every last drop of CF performance...
http://support.microsoft.com/support/kb/articles/Q197/3/79.ASP?LN=EN-US&SD=g
n&FR=0
At 02:43 PM 7/26/00 -0400, you wrote:
>You have to have at least 2 or 4 MB of swap file, I forget which one. Other
>than that, I don't see any reason why you shouldn't be able to disable the
>swap. Why do you think that the server would increase it's speed by
>disabling the swap file?
>
>Steve
>
>-----Original Message-----
>From: Gregory Harris [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, July 26, 2000 2:11 PM
>To: [EMAIL PROTECTED]
>Subject: RE: Milking every last drop of CF performance...
>
>
>Has anyone actually tried disabling the swap on an NT server? I've heard
>rumors that it is possible, and if it is, the server would probably pick up
>speed dramatically. Maybe I'll pull a spare web server and attempt it to
>see what happens. Anyone had the guts before?
>
>Gregory Harris
>Los Angeles ITA Dept.
>[EMAIL PROTECTED]
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>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.mail-archive.com/[email protected]/
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.
------_=_NextPart_001_01BFF734.DFE6BD60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Milking every last drop of CF performance...</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>If you wanna really get wacky....make a RAM drive =
(yes, you can do it in NT too) and set that to be the swap partition =
:-)</FONT></P>
<P><FONT SIZE=3D2>--b</FONT>
</P>
<P><FONT SIZE=3D2>"A product's only late once, but it can =
suck </FONT>
<BR><FONT SIZE=3D2> forever." -- Ben Spees, Ambrosia =
Software</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT =
SIZE=3D2> =
Bryan D. Batchelder </FONT>
<BR><FONT SIZE=3D2>Palm Wireless/Internet Application Developer</FONT>
<BR><FONT SIZE=3D2>W: 813.935.7100</FONT>
<BR><FONT SIZE=3D2>W: 813-936-8844 x 423 (after 5:30PM EST)</FONT>
<BR><FONT SIZE=3D2>H: 727-547-1322</FONT>
<BR><FONT SIZE=3D2>M: 727-808-4296</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>ConnectWise, Inc. (www.ConnectWise.com)</FONT>
<BR><FONT SIZE=3D2>2803 West Busch Blvd, Suite 204</FONT>
<BR><FONT SIZE=3D2>Tampa, FL 33618</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Jacob [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, July 26, 2000 3:09 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Milking every last drop of CF =
performance...</FONT>
</P>
<BR>
<P><FONT SIZE=3D2><A =
HREF=3D"http://support.microsoft.com/support/kb/articles/Q197/3/79.ASP?L=
N=3DEN-US&SD=3Dgn&FR=3D0" =
TARGET=3D"_blank">http://support.microsoft.com/support/kb/articles/Q197/=
3/79.ASP?LN=3DEN-US&SD=3Dgn&FR=3D0</A></FONT>
</P>
<P><FONT SIZE=3D2>At 02:43 PM 7/26/00 -0400, you wrote:</FONT>
<BR><FONT SIZE=3D2>>You have to have at least 2 or 4 MB of swap =
file, I forget which one. Other</FONT>
<BR><FONT SIZE=3D2>>than that, I don't see any reason why you =
shouldn't be able to disable the</FONT>
<BR><FONT SIZE=3D2>>swap. Why do you think that the server would =
increase it's speed by</FONT>
<BR><FONT SIZE=3D2>>disabling the swap file?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Steve</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>>From: Gregory Harris [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</=
A>]</FONT>
<BR><FONT SIZE=3D2>>Sent: Wednesday, July 26, 2000 2:11 PM</FONT>
<BR><FONT SIZE=3D2>>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>>Subject: RE: Milking every last drop of CF =
performance...</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Has anyone actually tried disabling the swap on =
an NT server? I've heard</FONT>
<BR><FONT SIZE=3D2>>rumors that it is possible, and if it is, the =
server would probably pick up</FONT>
<BR><FONT SIZE=3D2>>speed dramatically. Maybe I'll pull a =
spare web server and attempt it to</FONT>
<BR><FONT SIZE=3D2>>see what happens. Anyone had the guts =
before?</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT SIZE=3D2>>Gregory Harris</FONT>
<BR><FONT SIZE=3D2>>Los Angeles ITA Dept.</FONT>
<BR><FONT SIZE=3D2>>[EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>></FONT>
<BR><FONT =
SIZE=3D2>>-----------------------------------------------------------=
-------------------</FONT>
<BR><FONT SIZE=3D2>>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>>To Unsubscribe visit </FONT>
<BR><FONT SIZE=3D2>><A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or </FONT>
<BR><FONT SIZE=3D2>>send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in </FONT>
<BR><FONT SIZE=3D2>>the body.</FONT>
</P>
<BR>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.mail-archive.com/[email protected]/" =
TARGET=3D"_blank">http://www.mail-archive.com/[email protected]/=
</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFF734.DFE6BD60--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.mail-archive.com/[email protected]/
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.
