The reason for a new headers table is not so that the headers are taken out of the messageblks table, but rather because we want some of those headers to be pulled out and stored in columns of their own.
The new table would have just a messageid and a few columns named after the most often used headers. I would expect these all to be indexed, btw. The actual header itself *should* be stored verbatim and intact as a chunk of the message, but a "fastheaders" table that holds From, To, Subject, Date and few others will dramatically speed up many simple IMAP listing operations as well as your most common searches. Aaron On Thu, 3 Jul 2003, lou wrote: > In some email I received from "Matthew T. O'Connor" <[email protected]> on 03 > Jul 2003 > 10:25:02 -0400, wrote: > > > > > > > > > > > Should this not be part of the messages table ? > > > > Well some people were saying that there is an advantage to being able to > > get to the message headers independent of the message body. Also the > > current scheme of putting the headers in the first chunk of the > > message_blks table has the possible problem of having more headers than > > fit in a chunk. Putting them into their own table solves these > > problems. > > Why? > cant you simply create a column name message_headers? why do you need to > create > a new table? > > > > >message_body: contains the remainder of the message, could be broken up > > > >like the current message_blks table or not, I would prefer not, but I > > > >don't know if mysql is up to it. > > > > > > The message contents and headers should be stored in a binary type > > > rather than a text type so encoding does not become an issue. > > > > How does this work now? Does DBmail have problems with some non 7bit > > languages? I have use english. > > encode it, if you want you can even compress it, > gz_mess = gz_message(message) > uu_mess = _uu_message(gz_mess) > insert_message(uu_mess) > > but that will be a hit on the performance.. > (though this pseudo code might not be worth trying it even.) > > cheers > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
