> In any case, if you're concerned about performance, there are places that
> are far better to examine, such as your database queries. Have you run
> SHOWPLAN with them (if you're using SQL Server, for instance)? Are you
> testing your stored procedure performance? Are you updating DB statistics?
> You'll get a much better return on investment looking at your SQL, from a
> performance perspective.
Actually, to extend from this - if you're REALLY concerned with performance,
look at your hardware setup!
If you're running SQL Server, put it on it's own machine, with at least
512Mb RAM, and ONLY have SQL Server running on it. I believe the same
applies to Oracle, but not 100% sure.
Put at much RAM in your CF machine(s) as possible.
Get the fastest hard disks into all of the machines - but make sure they are
reliable - IBM are probably the best drives on the market at the moment.
Make sure you're running the fastest processors possible, and the fastest
RAM.
Make the hard disks SCSI, they're faster than EIDE ones, if you have to run
EIDE, get a separate hard disk controller, don't use the on-board one, oh,
and make sure it's UDMA66.
Load as few services onto NT as possible, they take processor time, which
slows down the whole thing.
It'll be a lot more worth-while upgrading to the latest specs of machine,
than spending hours trying to tweak each template to squeeze a fraction of a
second off of it... of course, doing both is the best of both worlds <g>
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
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.
