You may find that it is the index that is slowing you down. Have you
tried disabling the index(s) on your table before the delete and
re-enabling them after?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Todd Gruben [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003
At 9:01 -0500 6/9/03, Todd Gruben wrote:
In an effort to speed up large batch deletes i devised this script.
LOCK TABLES t1 WRITE;
SELECT * INTO OUTFILE '/data/dump/t1' FROM t1 where date=2003-06-09;
TRUNCATE TABLE t1;
LOAD DATA INFILE '/data/dump/t1' INTO TABLE t1;
UNLOCK TABLES;
this script
At 11:01 -0500 6/9/03, Todd Gruben wrote:
in the TRUNCATE TABLE t1
This is the documented behavior:
http://www.mysql.com/doc/en/TRUNCATE.html
You cannot use TRUNCATE on tables for which you hold locks.
On Monday 09 June 2003 10:57 am, you wrote:
At 9:01 -0500 6/9/03, Todd Gruben wrote:
In an