On Sonntag 14 Dezember 2008 Paul J Stevens wrote:
relies on foreign keys to remove the dependent data, or a
subsequent run of dbmail-util to clean out the disconnected parts.
That's a totally reasonable expectation on both counts -- Paul
added foreign keys in the 2.2 schemas, and if they're missing for
some reason then dbmail-util will clean out the leftover pieces
later.
And after all that's what we have a database for. It should do the
dependency-deletes itself, that's for sure the fastest way to do it. I
had deleted 220.000+ messages, and it took ages to run dbmail. At some
point I hand-deleted the messages with above statement, that took some
seconds. A great performance benefit.
agreed. Michael, plz file a bug report for this so I wont forget
about this.
OK, bug #746.
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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
well, nothing much too add, besides thanks for your efforts!
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
