2006/6/20, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi All, I am using INNODB.I have a delete quetry something like this : delete from modnaptrrecord_zone where modnaptrrecord_zone.modnaptrrecord_id in (593536 ,593537 ,593538 ,593539 ,593540 ........) and modnaptrrecord_zone.modnaptrrecord_id not in (593536 ........................)
I hope this is just some quick copy/paste, but if in your query you have : IN (A, B) AND NOT IN (A,B), I don't think it will return much data... Is there any index on modnaptrrecord_zone.modnaptrrecord_id ? ALTER TABLE modnaptrrecord_zone ADD INDEX(modnaptrrecord_id); Where did you get the list of ids ? you may be better off using a temporary table and doing an inner or left join on it. -- http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
