NM Public wrote:
Sur 2006-06-09, Marc Perkel skribis:
Perhaps the headers and other information that you would index be
kept in the database and the body of the message stored somewhere
else, perhaps even as files.
It seems that this is what Zimbra does. Check out my blog post here:
For IMAP, "SQL just sucks"
<http://deflexion.com/2006/06/for-imap-sql-just-sucks>
especially the comment from KevinH of Zimbra, which includes this:
"It's true that as a mailstore SQL sucks. Databases are not designed
to store large blobs of data. However in Zimbra's case messages aren't
stored in the database. Only *meta* data is stored behind a SQL
interface. [...]"
I hope this is useful. Thanks for inspiring interesting discussion Marc!
Nancy
(sent via gmane.mail.spam.spamassassin.general)
I would defer to the smart people to figure out the details. However I
do wonder if the actual body content of the message would be best stored
in a file and the SQL used to store anything and everything you would
want to index. That would keep the SQL file size down if that's an
issue. However, SQL databases might have to be changed to accomodate the
needs to store email.
