Michael Monnerie wrote: > 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
That does go without saying. > > 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. Well, deleting that many messages will always be slow. And as always: patches are most welcome. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
