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: SQL Mail Delivery Options
From: Fredrik Thulin (ftpi.se)
Date: Fri Mar 31 2000 - 05:23:30 CST

-----Original Message-----
From: Brad Knowles <blkskynet.be>
To: Fredrik Thulin <ftpi.se>; Stefan Seufert <seufccsw.de>
Cc: postfix-userspostfix.org <postfix-userspostfix.org>
Date: Friday, March 31, 2000 12:53 PM
Subject: Re: SQL Mail Delivery Options

>At 9:50 AM +0200 2000/3/31, Fredrik Thulin wrote:
>
>>  Server version          3.23.11-alpha
>
> Does this work with earlier versions of MySQL?  Our experience
>with 3.23.x has been universally bad, and I don't know if we will
>*ever* make that upgrade.

Just tried with

Server version          3.22.27-log

and it works.

>>  My own testing with storing mail in blobs says that it is too slow for
>>  my needs, but it is definately possible.
>
> Yes, it should be technically possible in most any decent SQL
>database, but the real questions are:
>
> 1.  Is it fast enough for your needs?  Your own answer seems to be no.

Yes, what I tried to say was that 'my own testing shows that mail in blobs are
no good'. I agreed with you before, but after reading your last two messages
concerning the stability and your own personal experience with losing rows etc.
I agree with you even more. SQL seems very suitable to hold message index
information, but not the body of arbitrary sized mails.

I just wanted to show that there are functions that at least indicate it is
possible to read/write parts of blobs in MySQL.

/Fredrik