Having a flag on the messageblks is great for joins (see previous post); but
if there is the possibility of multiple header blocks that may pose a
problem.
However -- you could set the value to "1" for 1 header block, "2" for
multiple header blocks (or qty, etc) -- and then if when you do the simple
join:
E.g. select messages.*, messages.isheader, messageblks.messageblk as
headers from
messages,messageblks where
messages.message_idnr=messageblks.messageblks_idnr and
messageblks.isheader=1 order by <SORT KEY>
If the 'isheader' flag returned 1, then *just for that row* the client
applications could do a second pass where they looked up all the header
fields.
/Mark
PS. Happy with bouncing messages with long headers though myself -- bound to
be spammers...
> -----Original Message-----
> From: dbmail-dev-bounces@dbmail.org
> [mailto:dbmail-dev-bounces@dbmail.org] On Behalf Of Aaron Stone
> Sent: Friday, 19 March 2004 7:53 a.m.
> To: DBMAIL Developers Mailinglist
> Subject: Re: [Dbmail-dev] dbmail 2.0 rc4
>
> For the uber-large headers problem, would you rather bounce
> the message or add
> the is_header column to the messageblks table and allow for
> multiple header
> blocks? Also, since we currently pass the header around as a
> single char
> array, how would you propose to throttle the memory usage so
> that someone
> cannot DoS the server with garbage jigabyte headers?
>
> Aaron
>
>
> Ilja Booij <ilja@ic-s.nl> said:
>
> > Hi,
> >
> > I'd like to release rc4 tomorrow. Is anybody aware of any
> showstoppers
> > we have to fix before releasing rc4 other than the ones
> I'll mention below?
> >
> > * Headers > 512kB don't work. Messages get dropped.
> >
> > * code indentation: run indent -i8 -kr (unless anybody
> wants something
> > completely different :) )
> >
> > Ilja
> >
> >
> > _______________________________________________
> > Dbmail-dev mailing list
> > Dbmail-dev@dbmail.org
> > http://twister.fastxs.net/mailman/listinfo/dbmail-dev
> >
>
>
>
> --
>
>
>
> _______________________________________________
> Dbmail-dev mailing list
> Dbmail-dev@dbmail.org
> http://twister.fastxs.net/mailman/listinfo/dbmail-dev
>