Re: Why is this delete so slow? ( 90 seconds per 100 records)

[Ryan Stille]

Thanks for the help, I rewrote it as a subselect and it deleted all 10K 
records in two seconds.

DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON
subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL
-Ryan


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]