BLOBS in production system

I'm working on the design of an application that needs to store scanned images (about 60K to 120K tiff files). We're using an ORACLE DB to keep track of what images we have. We were thinking that for quicker/easier access, we could keep the images in a LONG RAW column in the DB. But we don't want the DB to get too big and we're going to have a lot of scanned images. So once images have reached a certain age, they'll be taken out of the DB and stored as files on optical disks. During the day, new images will be added and users will want to retieve images. Images will only be deleted (moved to optical) during off peak hours. Images will rarely be modified.

My question is... does this seem reasonable? feasible? Does anyone have experience with something like this in a production system? Can ORACLE really handle blobs?

Thanks for any input.
Carol Fetters
cfetters_at_iac.net Received on Wed Sep 28 1994 - 02:13:22 CET