Re: BLOB Question

amerar_at_iwc.net wrote:

> Hi All,
>
> I've actually never really worked with BLOB's or CLOB's. So, I have a
> question that maybe someone could answer:
>
> We need to store a bunch of scanned images. We can store them in the
> database as BLOBS, or we can store them on disk as an external file.
>
> Is there any advantage in how fast Oracle can access the object if it
> is stored as a BLOB rather than an external file? What about space?
> Do I save any space storing it in the database verses out of the
> database?
>
> Storing them in the database will no doubt make the database larger and
> slow down the exports, I assume.......
>
> Thanks for any advice.
>
> Arthur

There are numerous advantages to storing in the database. Among the security and the guarantee that when you request them they will actually be there.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)