From: "NM Public" <[EMAIL PROTECTED]>
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)
If you only own a hammer and (think) you know how to use a hammer
all jobs seem to turn into jobs that need a hammer to solve them.
SQL is just one more tool. Don't be pathetic and try to use a hammer
as a means to remove a tiny delicate screw. You might as well try
saving email as XML objects or compiled into Objective C source
code modules. This discussion has gone on long enough it's rather
plain that SQL is not a natural fit for email storage, hasn't it?
{^_^}
