On Thu, Oct 20, 2011 at 00:11, Derek Downey <de...@orange-pants.com> wrote: > Ah-hah! :) > > Actually, I did something similar to that a month or so ago. I ran into a > speed limitation on a not-small database (~3mill rows). So be careful. > > Luckily in my case, I put all the 'minimum' ids in a memory table with an > index and it solved it. It also was a cleanup script, and not something I > need to run everyday. >
Yes, this is also a cleanup script for a bunch of vBulletin private messages that should not have been sent. Have you seen the vBulletin database? Over 200 tables, no documentation! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
