From owner-freebsd-questions@FreeBSD.ORG Tue Jun 22 12:31:56 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 0B8A316A4CE for ; Tue, 22 Jun 2004 12:31:56 +0000 (GMT) Received: from internet.potentialtech.com (h-66-167-251-6.phlapafg.covad.net [66.167.251.6]) by mx1.FreeBSD.org (Postfix) with ESMTP id A574943D3F for ; Tue, 22 Jun 2004 12:31:55 +0000 (GMT) (envelope-from wmoran@potentialtech.com) Received: from working.potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id CE67369A50; Tue, 22 Jun 2004 08:31:35 -0400 (EDT) Date: Tue, 22 Jun 2004 08:31:34 -0400 From: Bill Moran To: Jan Grant Message-Id: <20040622083134.4b8e28df.wmoran@potentialtech.com> In-Reply-To: References: <20040621132006.2b1a296f.wmoran@potentialtech.com> <20040621172520.3544d6fe.wmoran@potentialtech.com> <20040621214348.GB63857@happy-idiot-talk.infracaninophile.co.uk> <20040621175626.3e762448.wmoran@potentialtech.com> <40D76DA3.9090809@mac.com> <20040621204111.6e684d45.wmoran@potentialtech.com> Organization: Potential Technologies X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386-portbld-freebsd4.9) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit 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 12:31:56 -0000 Jan Grant wrote: > 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. That would explain why Cyrus is so fast then. If only there was a way to do replication ... it'd be the perfect IMAP server. -- Bill Moran Potential Technologies http://www.potentialtech.com