> Does anyone know if there is a way to delete query results, > before the page > is done processing??? > I have a couple of pages that compile info and send mass emails, > but some of > the queries are only needed for a short period, but (correct me if I am > wrong) the results of those queries will stay in memory until the page is > done. Well, when one of the results can easily have over 50,000 > rows, that > is a lot of memory that could be freed up and either speed up the other > processes running, or allow more to be run simultaniously. Any answer or > push in the right direction would be VERY much appreciated.
<cfset myQuery=""> It (should) replace the query in memory with an empty string... but I think the template memory is held until the template has finished anyways 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. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
