make sure you use truncate table cfdata truncate table cfglobal
it's faster then DELETE FROM cfdata DELETE FROM cfglobal also it doesn't write a whole bunch of stuff to the SQL logs. BOL has more about it. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:49 PM To: CF-Talk Subject: RE: Purge cfVar db using SQL script Miles, I may be mistaken, but I think there is a custom tag or script on the gallery that can take care of this task for you. Mark -----Original Message----- From: Miles Fawcett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:31 AM To: CF-Talk Subject: Purge cfVar db using SQL script We are using CF5 in a clustered environment and would like to purge the cfVar db (MS-SQL7) using SQL. the tables are simple enough but I am interested in anyone has a script they know works are has any insight into this approach. We would like to purge all records older than 30 days. Thanks, Miles Miles Fawcett, President Interactive Applications Group (iapps) tel 202.265.3700 x105 - fax 202.318.0237 - ICQ:1864271 Washington * New York * San Francisco * Boston ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
