From: "Christian G. Warden" <[EMAIL PROTECTED]> > On Sun, Oct 12, 2003 at 05:18:37PM -0400, Matthew T. O'Connor wrote: > > Shouldn't the headers be separated from the message body? It would > > solve the problem above, and probably improve performance. There should > > be a message_headers table that just holds the part of the message body > > that contains the headers. > > Since there is only one set of headers per message, why not add a > headers field to physmessage?
If I understand physmessage correctly, nothing in physmessage is touched during a move (copy / delete) or a plain copy. If that's the case then I think putting the headers in physmessage is fine. > Does anyone have any insight into why messages are split into > messageblks? The only MySQL limit I could find that might cause > problems is max_allowed_packet, but that can be configured. I did try > increasing READ_BLOCK_SIZE, and got a memory allocation error from > dbmail-smtp, but I assume that can be fixed. This is one of the design decisions that surprised me when I first started using dbmail, I'm not sure why it's laid out this way either. The only thing I can think of is that it allows large messages to be dealt with in small chunks rather than in one big chunk.
