OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Subject: Re: Looking for help with Postfix SQL delivery
From: Brad Knowles (blkskynet.be)
Date: Thu Mar 23 2000 - 10:01:57 CST

At 6:54 PM +0300 2000/3/23, Michael Ju. Tokarev wrote:

> Just one question : do you really need this!? Storing mail in database
> is not a good idea, as it is a lot slower than "old plain-file" method,
> especially with large mails.

        Not to mention the fact that SQL databases in general, and MySQL
in particular, do not deal well at all with "BLOBs" (Binary Large
OBjects, i.e., anything that doesn't fit a well-defined record
format, such as e-mail messages which might be 512 bytes in total
length with all headers included or 10MB excluding headers with
multiple MIME bodyparts layered several deep).

        You're really asking for trouble if you try to do something like this. 

--
   These are my opinions -- not to be taken as official Skynet policy
======================================================================
Brad Knowles, <blkskynet.be>                || Belgacom Skynet SA/NV
Systems Architect, Mail/News/FTP/Proxy Admin || Rue Colonel Bourg, 124
Phone/Fax: +32-2-706.13.11/12.49             || B-1140 Brussels
http://www.skynet.be                         || Belgium