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: Brad Knowles (blkskynet.be)
Date: Sat Apr 01 2000 - 13:38:21 CST

At 11:27 AM -0500 2000/4/1, Greg Stark wrote:

> Alternatively you could do that awful hack of avoiding BLOBS by using several
> rows of varchars.

        That's precisely what AOL does, up to text-only messages of 27KB
in size. Attachments and anything larger gets stored externally.

> This has the advantage of allowing you to seek
>around in the
> message and some other neat effects. But it's really awkward and would make
> fetching and inserting the data slower I think.

        Those are problems that you'd have to look at and do some tuning
to find the right balance, etc.... 

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