compressing header info

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

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I have to ask again, because the number of physmessages and
messages 
differs greatly on our server:

On Mittwoch, 20. Juni 2007 Michael Monnerie wrote:
> > No. It's a known bug there are some checks missing
from the
> > maintenance code.
>
> OK, should I
> select * from dbmail_physmessage p left join
dbmail_messages m on
> (p.id=m.physmessage_id) where m.message_idnr IS NULL;
> to find out phymessages that have no message id?
>
> Then I could delete them using
> delete from dbmail_physmessage p left join
dbmail_messages m on
> (p.id=m.physmessage_id) where m.message_idnr IS NULL;
> Is this correct?



-- 
// 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

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail