Ryan Stille wrote:
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
Whoops, I meant that I rewrote it as a JOIN. It originally was a subselect. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]