Date: Mon, 11 Apr 2005 10:25:55 +0900 From: Joel <rees@ddcom.co.jp> To: freebsd-questions@freebsd.org Subject: Re: Anyone ever consider a filesystem served by MySQL for mail folders? Message-ID: <20050411102005.6047.REES@ddcom.co.jp> In-Reply-To: <20050411000641.GB620@Pandora.MHoerich.de> References: <20050409223001.GA58918@kirk.dlee.org> <20050411000641.GB620@Pandora.MHoerich.de>
next in thread | previous in thread | raw e-mail | index | archive | help
> > > The disadvantage is that you need to provide around 4 times as much disk > > > space for a DB-based mailstore as you would for a normal mbox/maildir style > > > representation, you need to provide a lot more server horsepower, you need > > > to continuously maintain and purge old mail from the database, and you end > > > up with your mail buried in database tables, so heaven help you if the > > > database becomes inconsistent and you need to recover. > > Whereas you can repair mbox-files with your favorite editor > and employ pretty much the same level of fancy searching > with a couple of scripts. I am not recommending a database to resolve this problem, but I'll note here that a text editor for searching has its limits when the bulk of the mail is Japanese (or any other predominantly non-Latin language). Speaking of which, anyone know of an editor/filter combination that can handle all the funny encodings used to make mail 7-bit safe? (Base 64 excepted, of course.) -- Joel Rees <rees@ddcom.co.jp> digitcom, inc. $B3t<02q<R%G%8%3%`(B Kobe, Japan +81-78-672-8800 ** <http://www.ddcom.co.jp>; **
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050411102005.6047.REES>