Re: Blob versus Server Directory

I found this code "http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=45&lngWId=9" that seems to do what I want.

Why would you recommend storing the files on a directory instead of Oracle? A BFILE what is that?

Mike

Sybrand Bakker wrote:

> Michael Hill <hillmw_at_ram.lmtas.lmco.com> wrote in message news:<3EBFC28B.2493021E_at_ram.lmtas.lmco.com>...
> > I have a need to have users save files that are associated with
> > particular records. We are talking about any file types, e.g *.html,
> > *.doc, *.gif, *.vsd, *.mpp, and many more.
> >
> > I understand there are a couple ways to do this:
> > 1) actually save the file as part of the record in an Oracle Blob field.
> > Never done this before. If you have any examples this would be great.
> > 2) for each record, create a directory on a server identified by the
> > record ( the key id ) and store that file out in that directory server.
> > Save the name of the file stored on the directory in an Oracle text
> > field.
> >
> > Anyone want to comment on which of these methods you think is preferred?
> >
> > I can do 2), but I have never implemented 1) above.
> >
> > Mike
>
> 1) Oracle provides documentation. There are usually examples in the
> documentation. Try to use it
> 2) Better use a BFILE instead of your own mechanism
> Obviously 2 is preferred as it takes less space and your table is not
> going to be subject to chaining.
>
> Regards
> Sybrand Bakker
> Senior Oracle DBA
  Received on Tue May 13 2003 - 16:43:08 CEST