Like Dave says, cfa_generatedContentCache and other caching options (see
Mary Horvath's caching KB) can get fantastic performance improvements. The
trick is to pick the right things to cache and to name the caches so that
there is a 1-1 correspondence between the generated HTML and the cache name.
Also remember that if you cache in memory you will loose your cache during a
restart - I once wrote a simple script that wddx'ed the server.cfa.cache
scope (where Spectra stores cache info) and saved it to a file before a
restart - reverse the process to get the cache back. I've seen developers
extend the caching idea to store other information along with the cached
HTML, e.g. line to log when the cache is used, list of objects whose method
output is contained in the cache (useful for deleting superceeded caches
when a new version of an object goes live). Be careful to properly lock
stuff when mucking around with the cache structure, see the
cfa_generatedContentCache[Flush] code to get the correct lock names.
Cheers,
Robin Hilliard
Senior Product Support Engineer - Asia Pacific
Macromedia, Inc.
-----Original Message-----
From: Dave Crosby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 22 May 2001 7:30 AM
To: Spectra-Talk
Subject: Re: Performance
You definitely need to separate SQL Server from CF
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
