BLOB Question

From: <amerar_at_iwc.net>
Date: 28 Feb 2005 13:05:39 -0800
Message-ID: <1109624739.330398.306240@f14g2000cwb.googlegroups.com>

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 Received on Mon Feb 28 2005 - 15:05:39 CST