I need to reduce size of DB in preperation for migration to another host.
I truncated two large tables ok in studio.
There is one large table I need to do selective delete. When I run it as a coldfusion template it just hangs ( I put in a max rows just as a test)
How do I put this in studio transaction sql language - may run better in studio. So hard code a date
Notification_Date is smalldateint and is indexed
<!--- delete old notifications ---->
<CFMODULE TEMPLATE='getnewdate.cfm' Days=600>
<cfoutput> #newdate# </cfoutput>
Notification.Notification_Date < #NewDate#
The page threw an error - timeout - even though I just selected 1000 rows
The Application Has Encountered an Error!
Here is some of the information that has been submitted to the site administrator.
Date of the Error: Wed Oct 01 18:59:13 EDT 2014
Browser being used: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.124 Safari/537.36
Remote Address: 10.0.0.72
Page on which error occurred:
HTML Code Format
The request has exceeded the allowable time limit Tag: CFQUERY <br>The error occurred on line 19.