Re: file as BLOB

The application is an intranet.
If the file is stored in the database the security is assumed with Oracle (User privileges) and if the file is in the directory (filesystem) it is Unix security

The other argument to prefer filesytem is the way to access big data. (for example if there is 100 pages, so there is many libraries that can handle and paginate results...)

As I'm bigenner with Oracle, can you give me reference to find samples with both cases to implement a prototype ?

Daniel Morgan a écrit :

> 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 - 02:13:44 CEST