"Roy Lambert" <[email protected]> wrote on 5.1.2010 10:10:45:
>To allow me to detech duplicates I store the message-id in a database field. I >have this currently defined as VARCHAR(80). I've started to receive some >emails with a message-id length of 99 (ridiculous but out of my control). What >length do others who store this header separately use ? >Roy Lambert Approx 105k messages. Minimum is a zero about 2% of messages. Average is a bit less than 40 characters. Maximum is 157 characters. P.S. using just hash of message-id is not ok, in my case I would get about 2% of collisions. Also don't forget about mailing lists. You'll get back the message with same id as your sent message, collisions again. sha-256 or sha-512 on all message headers might be ok :) Regards, Miha -- It's time to get rid of your current e-mail client ... ... and start using si.Mail. It's small & free. ( http://www.simail.si/ ) ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ synalist-public mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/synalist-public
