This discussion should move to dbmail-dev.
grtz,
Matthew T. O'Connor wrote:
On Thu, 2003-07-03 at 05:28, Gianni Mariani wrote:
Matthew T. O'Connor wrote:
Where is the schmea changes are being discussed? I haven't seen any
mention of it anywhere, I would like to be part of the discussion.
A quick design: perhaps something like the following.
messages: One row per message similar to the current messages table
except without all the flags.
message_flags: Keeps all the flags (seen, answered deleted).
id int4 primary key
flag_id int2 (references a list of possible flags in another table)
flag_value int2 (value of flag).
the advantage to this type of setup is that you use zero space for flags
that are equal to the default value. Also, when a flag changes it only
updates a very small row, now a larger row that has several flags. Also
it allows the definition of additional flags without changing the
database schemea.
This also reduces the number of indexes.
message_headers: similar to the current message_blks table except it
only keeps the portion of the message that contains headers. This fixed
the problem mentioned of a large set of headers and also easily flags
the message block that contains all the header information
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.
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.
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
