Re: Which one is faster: IMAP server or MySQL server?

Timo Sirainen <tss@xxxxxx> wrote:
On Fri, 08 Feb 2008 13:46:27 +0000, NM Public wrote:

For IMAP, "SQL just sucks"
<http://deflexion.com/2006/06/for-imap-sql-just-sucks>

I see it has a comment about Zimbra storing metadata to SQL and message
bodies to files. My original comments about "why SQL sucks for IMAP" was
actually more about metadata than bodies.

Implementing a well performing IMAP server is mostly about minimizing
disk I/O usage as much as possible. Designing index files specifically
for IMAP can get a lot better performance than using a generic SQL
server. For example some data may be accessed much faster if the data is
stored in column-oriented way rather than row-oriented. Or the server may
even store the data in both ways to optimize for two different clients or
commands (e.g. SORT (RECEIVED) vs. FETCH 1:* (INTERNALDATE ENVELOPE
BODY)).

while obviously not IMAP based, the original hotmail was able to scale to
a large size because they split all message headers and metadata from the
bodies of the messages.

Until you actually checked a message, the message body wasn't even
touched.
.

Relevant Pages

  • Re: OT: why do web BBSs and blogs get so slow?
    ... As a result I've poked around in the Slashdot SQL ... the list of stories itself, but there are also lists of subsections (Apache, ... > be a fixed length of metadata for each message, ...
    (comp.lang.python)
  • RE: Importing several text file into several tables
    ... Are you using SQL 2000 and DTS? ... How would you handle it if you package only processed one single ... I have many text files on a folder with the same metadata and I need to ... (the format of the files is not known but they have the same format) ...
    (microsoft.public.sqlserver.dts)
  • Re: Documents in SQL Server
    ... You would need to use a SqlBinary reader or something in a .NET ... any tools in SQL or Query Analyzer to do this). ... > update -- I see metadata in the Docs table, ... > "nancyk" wrote in message ...
    (microsoft.public.sharepoint.portalserver)
  • Re: elegent way to handle "pluggable" backend servers?
    ... For most selects it isn't that hard to turn metadata ... about the query into vendor SQL. ... That can easily be shoved into a single factory ... The handler classes all implement a few hooks like ...
    (perl.dbi.users)
  • Re: Which one is faster: IMAP server or MySQL server?
    ... I see it has a comment about Zimbra storing metadata to SQL and message ... actually more about metadata than bodies. ... IMAP's SEARCH TEXT/BODY command violates the IMAP protocol, ...
    (comp.mail.imap)