Re: file as BLOB

cava123_at_noos.fr wrote:

> Hi all,
> (Solaris 2.6/Oracle 8172 -distributed database-)
> My Pb is about BLOB, and here is a sample of what I want to do :
> Suppose we have an application written in java : name_of_author,
> Title_of_the_book, the_book (as BLOB)
> And a client (may be every where in the web) can read a book online when he
> knows the title
> My question : What is the best practice for performance.
> store the file (the_book) into the database
> or store it in a file system ?
>
> I think that the filesystem is the best idea :
> reasons :
> 1) Performance based OS (Unix) is better than access the file throw SQL...,
> 2) managing filesystem is easier than managing a database
>
> can anybody give me some help ?
> (if possible improve the two solutions with sample to implement it)
> Thanks
> yhab.abiad-sica_at_renault.com

If there are no security concerns I'd agree. I'd put it in the database only if you had a reason for an additional layer of security.

Daniel Morgan Received on Tue Jun 25 2002 - 01:27:43 CEST