;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
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 TAB
8:02 AM
To: [EMAIL PROTECTED]
Subject: Batch Deletes...
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/du
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 would w
