OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Why is this delete so slow? ( 90 seconds per 100 records)

From: Ryan Stille (ryancfwebtools.com)
Date: Fri Apr 11 2008 - 10:54:12 CDT

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