Blob versus Server Directory

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Mon, 12 May 2003 10:49:31 -0500
Message-ID: <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 Received on Mon May 12 2003 - 17:49:31 CEST

This message: [ Message body ]
Next message: Pierre Tremblay: "SQL update statement and TIMESTAMP"
Previous message: Michael Hill: "Re: Record Locking ???"
Next in thread: Sybrand Bakker: "Re: Blob versus Server Directory"
Reply: Michael Hill: "Re: Blob versus Server Directory"
Reply: Sybrand Bakker: "Re: Blob versus Server Directory"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message