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
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
