On Montag, 18. Juni 2007 Paul J Stevens wrote: > I've pushed this new feature onto dbmail_2_2_branch.
Good. I've modified your query from another thread to find duplicate
message-ids:
select count(*),n.headername, headervalue from dbmail_headervalue v join
dbmail_headername n on n.id=v.headername_id where
n.headername='Message-Id' group by
headername_id,n.headername,v.headervalue order by count(*);
10 | Message-Id |
<[EMAIL PROTECTED]>
11 | Message-Id | <[EMAIL PROTECTED]>
12 | Message-Id | <[EMAIL PROTECTED]>
16 | Message-Id | <[EMAIL PROTECTED]>
34 | Message-Id | <[EMAIL PROTECTED]>
34 | Message-Id |
<[EMAIL PROTECTED]>
34 | Message-Id | <[EMAIL PROTECTED]>
And this is just a small test system with 10GB database size. So
duplicate suppression could be interesting. I'm wondering if these
really have the same content though.
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
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
