Wouldn't it be possible to save a lot of space by compressing the contents of the various header tables?
dbmail_envelope dbmail_headervalues dbmail_fromfield etc. They all contain thousands of entries with the same value. In case of dbmail_envelope, it's just the date that differs, but all those automated e-mails have the same subject etc., that contents could be compressed. It's not about disk space (just a bit), but more about content access speed and caching. Having thousands of same entries pollutes the cache, and having a DB should help reducing this problem. When you're already working on compressing the contents, maybe there's an idea for this also? 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
