Hi.
I just noticed that my daily dbmail-util run was taking like forever to
run. At first I was confused as to why but then I remembered somethign
on the git log (I am using abac5b58c94f270e534320ff264054bc79530b78 at
the moment for testing) and found this:
http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=a40b41d783fde2ff2304dd8bb61a70448be26810
Now I have a postgres process for this connection:
(from top)
11069 postgres 20 0 114m 79m 76m R 97,8 0,5 1821:00 postgres:
dbmail dbmail ::1(47006) DELETE
this seems to be terribly inefficient (transaction start, DELETE,
transaction commit - rinse&repeat).
It might be because I got quite a lot of mails in there which are
migrated from an old db, but the time this takes is still rather long
imho.
I don't know about all the DB backends, but wouldn'T it be a lot more
efficient to do this in one query (with subselect) or a - very short
stored procedure (which should be easy to maintain on all the
platforms).
as it stands now I can't really run this daily anymore :(
Regards
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
