Create a storedproc that either takes the query name as an input parameter, or knows the query name and performs the deletion.
Israel Rose > -----Original Message----- > From: Christian Watt [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 01, 2001 3:08 PM > To: CF-Server > Subject: Deleting a Query??? > > 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. > > Thank You, > Christian Watt > SkillPath Seminars > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
