On Montag, 10. September 2007 22:29 Jesse Norell wrote: > I'm no sql wizard, but wouldn't that be a pretty bad performance > hit? (Every time a message is deleted it does that?) I believe the > physmessageblks got left around when deleting a user (eg. it deleted > the users' mailboxes and messages, but not physmessages); if the > above is indeed a performance drag (but maybe unnoticed on a > low-volume server?), maybe you could rewrite it to act ON DELETE of > the mailbox, which should happen much less often?
The server is not in stress, and even if I can't see how much effort this rule makes. It's only one select after all, and shouldn't be a big hit. > Did you manually clean up the existing cruft at the time you added > the above rule? Yes, I did. Several times. It keeps coming again, but I don't know from where. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
pgpTsZ7mf6Y87.pgp
Description: PGP signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
