Script is slowwww.
Posted 24 November 2005 - 08:29 PM
There are about 1.6 million records, and the query will expunge about 950,000 of them.
The script seems to run forever, eventually, by computer says the query browser is no longer responding...
Is it normal for a script like that to take over an hour? or do I have something configured wrong maybe?
BTW, why doesn't this work?
delete from test.labor where `DateNew` =< 1997-01-01;
Posted 25 November 2005 - 06:00 PM
you should quote the date value, and it's <=, not =<
dateNew <= '1997-01-01'
or [php] * 1000... PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...
Posted 25 November 2005 - 07:37 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users