Hi, I'm deleting about 15GB of mail, from unused mailboxes.
I've done this by setting status=3 and then running dbmail-util. Which is now running for hours and hours.
So I started checking which statements are executed, if I'm right it is doing:
SELECT physmessage_id FROM dbmail_messages WHERE message_idnr = 7714566; DELETE FROM dbmail_messages WHERE message_idnr = 7714566; SELECT message_idnr FROM dbmail_messages WHERE physmessage_id = 4015611; DELETE FROM dbmail_physmessage WHERE id = 4015611; DELETE FROM dbmail_messageblks WHERE physmessage_id = 4015611; Now the questions are: 1) What use has the second SELECT statement? 2) Why are you not using a transaction for this? (Or did I mis that?) 3) Is there no way to batch multiple deletes with per statement? Marc _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
