Michael Monnerie wrote: > 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.
I propose we drop the index, but keep the hash as a varchar. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
