> Setting the deleted_flag=2 is not the same as setting status=2! > > deleted_flag=2 is meaningless.
Ops you're right, I used the 1st column I saw, my error. > > Now, one thing I've noticed is, when running the dbmail-util > commands, it > > takes about one hour, to delete 196 mimeparts or 2000. > > I notice it does the full query twice, which shouldn't be necessary. > Optimizing that would cut the overall time in half, still taking half > an hour in your situation. It was my impression also when I counted the time of the two steps, when possible, remove the duplicated query :) > > Not much we can do to improve that. Cleaning up orphaned mimeparts is > by definition a slow process. It requires a full index scan on the > mimeparts table. No problem on this, the hardware I have is also slow for the current days. Removing the duplicated query, it'll result in +/- half hour with a 50GB database on an old hardware, which is in fact a bit fast. _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
