Also the table seems to be locked while running this delete... thats not going to be very good when I need to run it on production. Is there a way to have it not be locked during this delete?

I'm thinking of creating a script to delete in 10 row increments until they are all gone.

Thinking about it now... its probably the IN clause, isn't it? I've heard those are slow. Hopefully someone will have a better idea.

Thanks,
-Ryan


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

Reply via email to