Where to store BLOB's

From: àãø éçéàì <adary_at_mehish.co.il>
Date: Tue, 29 Jan 2002 10:06:52 -0800
Message-ID: <F001.003FEEC7.20020129085531@fatcity.com>

Hello all

We are designing a new application.
This application stores files that were FTP to the clients and keep then for resubmitting (if the user ask for them). There are two formats:
1) Standard records whose internal format is known.

These files lets the user ask for a subset of the records, i.e. all the records for branch xxxx that were submitted in the last week, etc. . 2) Strange files that are moved as a file.

Here the application is not aware of the internal format, i.e. excel files, and these files are going to be stored as Blob's and the user can ask only for the whole file again.

I know that you can store Blob's in three ways: (already rtfm a little)

1) In the record (up to 4k), more goes to another tablespace.
2) In Oracle but in another tablespace (always).
3) As external files.

I would like to learn from your experience what is the best, easiest to implement, easiest to admin, less demanding on Oracle and all the good stuff.

TIA Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 29 2002 - 12:06:52 CST