On Donnerstag, 31. Mai 2007 Charles Marcus wrote: > By storing the constituent parts of a message in a DB, and > MD5-summing them (or whatever algorithm floats your boat), you can > very easily allow for single-instance-storage, so that if someone > completely different sends or receives a message with > funny_picture.jpg (25MB) as an attachment, and this file already > exists in the message store, it is simply linked to, not stored... > > This capability alone would probably reduce my mailstore by 80+%.
That's what I suggested some time ago, see thread "max messageblk size changeable?" from 15. March 2007. I checked logs, and those funny mails often reach a large amount of users. Especially within bigger companies. One receives it, then re-sends to some collegues... By storing each attachment separate, you not only save storage, also performance is increased a lot (using the cache more efficient), and by searching for references to it you can do nice statistics (which files are used how often...). I'd love to make stats "we saved 16GB storage just for this .ppt". 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
