Thanks again Paul. > Then the person who told you doesn't understand dbmail's storage model > either :-)
You told me that in your first answer... so I thought it was right. =) > In 2.2 a whole list of new tables were added in order to cache the > headers in a preparsed and normalized form: > dbmail_headername: registers all used header-names (From, To, etc.) > dbmail_headervalue: registers all used header values in the correct > encoding. > dbmail_subjectfield: the base-subject (the raw subject minus all the > forwarding/reply cruft) also in the correct encoding > dbmail_datefield: stores the Date header as a datetime sqlfield > dbmail_referencesfield: the References header > dbmail_fromfield, dbmail_tofield, dbmail_ccfield, dbmail_replytofield: > cache the address fields in a preparsed and correctly encoded form Thanks for this explanation. In http://www.dbmail.org/dokuwiki/doku.php?id=er-model only version 2.0 is explained. > In 2.3 (coming soon) the base storagemodel has changed yet again: How soon? Do you have any prediction? Gonçalo Duarte 2007/10/18, Paul J Stevens <[EMAIL PROTECTED]>: > > Gonçalo Duarte wrote: > > Sorry it's my fault surely... > > > > I started yesterday reading dbmail 2.2.7 code. > > > > It has been said to me that the message is stored in one big blob. > > Then the person who told you doesn't understand dbmail's storage model > either :-) > > > > > And they asked me to try to store the message info (to, from, cc, > > subject, body, attachments) all in separate fields. > > > > Am I saying something wrong? Is that possible to do what asked me for? > > In dbmail 1.0, 2.0, and 2.2 messages are stored in two (or more blobs): > > the first block contains the message headers, the second and following > blocks contain the message body split into parts (since mysql-3 had a > limit on the maximum size of a TEXT field). > > In 2.0 the first block (which contains the headers) was marked as such, > so imap had an easier time retrieving and parsing them. > > In 2.2 a whole list of new tables were added in order to cache the > headers in a preparsed and normalized form: > > dbmail_headername: registers all used header-names (From, To, etc.) > dbmail_headervalue: registers all used header values in the correct > encoding. > dbmail_subjectfield: the base-subject (the raw subject minus all the > forwarding/reply cruft) also in the correct encoding > dbmail_datefield: stores the Date header as a datetime sqlfield > dbmail_referencesfield: the References header > dbmail_fromfield, dbmail_tofield, dbmail_ccfield, dbmail_replytofield: > cache the address fields in a preparsed and correctly encoded form > > These caching tables allow better support for searching, while > respecting the charset used in the search command. > > In 2.3 (coming soon) the base storagemodel has changed yet again: The > dbmail_messageblks table will be deprecated and replaced by two new > tables: dbmail_mimeparts and dbmail_partlists. > > During storage messages are split into their mimeparts and stored as > such (or more to the point: mimeparts are split into header/payload > which are stored separately). Any mimepart that is stored is never > stored more than once in the whole database (something I call > single-instance storage). So receiving the same image or pdf again and > again will not bloat your database, even when sent under another filename. > > To sum, most of what you ask for is already present in 2.2. Separate > storage of attachments is in the trunk code, but hasn't been released yet. > > -- > ________________________________________________________________ > Paul Stevens paul at nfg.nl > NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev > -- A humanidade está a perder os seus maiores génios...Aristóteles faleceu... Newton bateu as botas... Einstein morreu... e eu não me estou a sentir lá muito bem...
_______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev
