From owner-freebsd-questions@FreeBSD.ORG Tue Jun 22 09:43:45 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 504A916A50A for ; Tue, 22 Jun 2004 09:43:45 +0000 (GMT) Received: from dirg.bris.ac.uk (dirg.bris.ac.uk [137.222.10.102]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB3C143D58 for ; Tue, 22 Jun 2004 09:43:44 +0000 (GMT) (envelope-from Jan.Grant@bristol.ac.uk) Received: from mail.ilrt.bris.ac.uk ([137.222.16.62]) by dirg.bris.ac.uk with esmtp (Exim 4.34) id 1Bchob-0002mn-Ml; Tue, 22 Jun 2004 10:43:42 +0100 Received: from cmjg (helo=localhost) by mail.ilrt.bris.ac.uk with local-esmtp (Exim 4.34) id 1Bchmg-0004JE-5T; Tue, 22 Jun 2004 10:41:42 +0100 Date: Tue, 22 Jun 2004 10:41:42 +0100 (BST) From: Jan Grant X-X-Sender: cmjg@mail.ilrt.bris.ac.uk To: Bill Moran In-Reply-To: <20040621204111.6e684d45.wmoran@potentialtech.com> Message-ID: References: <20040621132006.2b1a296f.wmoran@potentialtech.com> <20040621172520.3544d6fe.wmoran@potentialtech.com> <20040621214348.GB63857@happy-idiot-talk.infracaninophile.co.uk> <40D76DA3.9090809@mac.com> <20040621204111.6e684d45.wmoran@potentialtech.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Jan Grant X-Spam-Score: 0.0 X-Spam-Level: / cc: questions@freebsd.org Subject: Re: [OT] Re: What's the best possible email failover solution X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Jun 2004 09:43:45 -0000 On Mon, 21 Jun 2004, Bill Moran wrote: > During my research of the IMAP protocol, I determined that _the_best_ > way to store email for high-performance would be to put them in a > database. This is because IMAP doesn't see email as a big blob of > text like POP does. It sees the headers as one thing, and the > different MIME parts of the email each as a seperate thing that can > be fetched independently of the other MIME parts. This is a pretty > good layout for a one -> many relationship in a database. Fact is, > every current IMAP server that I'm aware of has to break emails > apart on the fly in order to server IMAP. Have a closer look at the cyrus layout. Each message is in a single file, true, but they are also preparsed to extract the data required for common IMAP operations. The index files contain things like preformed bodystructure responses and offsets to each mime piece. -- jan grant, ILRT, University of Bristol. http://www.ilrt.bris.ac.uk/ Tel +44(0)117 9287088 Fax +44 (0)117 9287112 http://ioctl.org/jan/ HP-unix: Open Sauce product, available in 57 distributions.