Hi Paul, I've just been looking why dbmail-util -tpubdsy runs so slow, and it seems it generates lots of single deletes like:
DELETE FROM dbmail_physmessage WHERE id = 1653477 Couldn't that be grouped in bigger deletes, like DELETE FROM dbmail_physmessage WHERE id in (1653477, 2, 3, 4, 5, 6, 7, 8 ,9, 10) That should help performance a bit. I just deleted some accounts with 220.000+ messages and about 8+ GB size, that's why it takes long. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
