Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Store files as BLOB

Store files as BLOB

From: <cava123_at_noos.fr>
Date: Tue, 25 Jun 2002 01:18:45 +0200
Message-ID: <3d17a554$0$8462$79c14f64@nan-newsreader-02.noos.net>


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 Received on Mon Jun 24 2002 - 18:18:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US