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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
