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: Stefan Seufert (seufccsw.de)
Date: Thu Mar 30 2000 - 09:53:11 CST

> > Well, I did it... I implemented a very small MDA doing this for testing.
> > The
> > main problem was not performance, the main problem is memory
> > consumption.
> > Storing your Mails in a file has one great advantage... You never need
> > more
> > memory than a small buffer able to hold a few lines. When you use a
> > database, you need to reserve a buffer large enough to hold the whole
> > message. This might be fine if you do not allow messages bigger
> > than 2 MB
> > and have a low number of parallel operations, but are you sure you have
> > enough memory to serve a peak?
>
> Only if you try to write the whole BLOB to the database at once, which is
> painful; most databases provide APIs for dealing with BLOBs in a piecemeal
> fashion to get around this problem.

OK, agreed, but the discussion was about mySQL and mySQL does not have such
functions AFAIK.

Stefan