From owner-freebsd-questions@FreeBSD.ORG Mon May 22 03:33:24 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org 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 0D1BE16A42B for ; Mon, 22 May 2006 03:33:24 +0000 (UTC) (envelope-from on@cs.ait.ac.th) Received: from mail.cs.ait.ac.th (mail.cs.ait.ac.th [192.41.170.16]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7930143D48 for ; Mon, 22 May 2006 03:33:22 +0000 (GMT) (envelope-from on@cs.ait.ac.th) Received: from banyan.cs.ait.ac.th (banyan.cs.ait.ac.th [192.41.170.5]) by mail.cs.ait.ac.th (8.13.1/8.12.11) with ESMTP id k4M3XDXw050099 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Mon, 22 May 2006 10:33:13 +0700 (ICT) Received: (from on@localhost) by banyan.cs.ait.ac.th (8.13.3/8.12.11) id k4M3X8c3031287; Mon, 22 May 2006 10:33:08 +0700 (ICT) Date: Mon, 22 May 2006 10:33:08 +0700 (ICT) Message-Id: <200605220333.k4M3X8c3031287@banyan.cs.ait.ac.th> From: Olivier Nicole To: cswiger@mac.com In-reply-to: <446F18E9.70801@mac.com> (message from Chuck Swiger on Sat, 20 May 2006 09:26:01 -0400) References: <59825.24.1.139.244.1148088476.squirrel@mail.dfwlp.com> <446F18E9.70801@mac.com> X-Virus-Scanned: on CSIM by amavisd-milter (http://www.amavis.org/) Cc: freebsd@dfwlp.com, freebsd-questions@freebsd.org Subject: Re: email with a database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 May 2006 03:33:24 -0000 > > is there an email solution that employs some kind of database that stores > > mail for long term? id rather not turn on "leave a copy on the server" as > > this has shown to give poorer and poorer performance over time for me. > People normally take backups of their machines in order to protect > against losing files, including your email. You should be using IMAP > instead of POP3 if you want your email to reside on the server efficiently. In fact you would want to use maildir format instead of mbox format for your mailbox. That you use imap or pop3 is of little relevance on the speed. Format of the mailbox is though. In standard mbox format you have to open and manipulate one single huge file, that keeps growing bigger and bigger. Browsing that file to find the new/unseen messages can take several tens of second when your mailbox gets too big. In maildir format, you manipulates one file per message, new messages being in a different directory from the seen messages. That makes the file manipulation much faster. Of course you can make tape archive of your mailbox (easier to archive maildir format though as there is not risk of concurent access to a message file). And you can use procmail or the like to duplicate the message in a file on your server. Best regards, Olivier