On Dienstag 24 Februar 2009 Michael Monnerie wrote: > As we can drop dbmail_headervalue_3 index anyway, drop that 255 char > field also, and store only the full headervalue. Use that nice > compressing technique Niki implemented already, but without hash. > That might be more overhead than searching the whole table. If it > needs be used, use a hash as short as possible to save storage. A > cheap md5 hash should be enough, maybe less is possible.
Niki, any chance you can work on this? I missed you in the discussion. I'm trying to find the best way to handle this, but I'm not a coder (anymore) and would like to hear your opinion. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4 _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
