This thread was started as a hardware query.
Steve
-----Original Message-----
From: David Sparkman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 26, 2000 5:29 PM
To: [EMAIL PROTECTED]
Subject: RE: Milking every last drop of CF performance...
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
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
