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: Jakob Schlyter (jakobcrt.se)
Date: Thu Mar 30 2000 - 09:24:05 CST

On Thu, 30 Mar 2000, Stefan Seufert wrote:

> 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?

You could split the message into smaller chunks and read and write the
chunks as you go if you want to minimize the need of memory.

/Jakob 

--
Jakob Schlyter <jakobcrt.se>                Network Analyst
Phone:  +46-31-701 42 13, +46 70-595 07 94   Carlstedt Research & Technology