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: Christopher E. Brown (cbrowndenalics.net)
Date: Mon Apr 03 2000 - 15:32:14 CDT

On Fri, 31 Mar 2000, Robert Bradman wrote:

> Maybe you're thinking of something else. I've been using MySQL for months
> and have had no lost rows, no missing tables, nothing but pure stability. I
> can imagine how this might conflict with your observations of
> MySQL/Sybase/MS-SQL, but the truth is that if you implement it properly you
> wont have much of an issue doing this sort of thing.
>
> Blobs in a 200 gigabyte table might be bad. But a few hundred blobs in one
> table that rarely get moved/touched will be fine.
>
> -- Robert

        I can go further, I have been using MySQL since 1996, and have
had very few issues. MySQL is not a minor opensource project, it is a
database system that the people at TcX wrote for their own use,
dealing with many hundreds of millions of records. They were nice
enough to make is publicly available.

        There is (IIRC) a 24MB limit on blob size in the current table
system, however I have been using BLOB storage for documents for
several years, with *no* issues. We have a system, all
incoming/outgoing faxes (hylafax server) are saved in, and many
thousands of postscript, pdf, jpg, etc items are stuffed in the DB.

        We use it for document storage/indexing, backing the auth
system, inventory, directory services, and of course backing postfix.
We have yet to see any data loss.

 ---
As folks might have suspected, not much survives except roaches,
and they don't carry large enough packets fast enough...
        --About the Internet and nuclear war.