> If I've got a template that does a huge amount of processing, with many
> queries and other memory-intensive operations, I'd just as soon release
> memory ASAP _during_ the processing of the template. Once again, I'm not
> sure how to do this, or even if CF's memory management and deallocation
> mechanisms go into play before a template is fully processed. It would be
> good to know, however.
Why not just do a CFSet?
AFAIK, CF's memory allocation is dynamic, so as soon as you set another
variable it kills the existing memory...
<cfquery name="myQuery" datasource="DSN">
select ID
from Table
where ID between 10 and 200
</cfquery>
<cfset myList=ValueList(myQuery.ID)>
<cfset myQuery="">
Philip Arnold
Director
Certified ColdFusion Developer
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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
