uch a beast exist?
---
Todd Gruben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Any reason why a SELECT which finds no matches returns instantly
but an update which has the same where clause takes about 2 secs to return.
explain reports that the select is exaninng 10 rows in a 300,000 row table.
which is exactly what i am expecting.
are there any know issues?
-Todd
--
M
how do your set the index type in 4.1? My tables still appear to hash
indexes.
-Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 work great without the LOCK TABLES