Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Storing blobs in database vs filesystem

Storing blobs in database vs filesystem

From: Sandeep Dubey <dubey.sandeep_at_gmail.com>
Date: Thu, 28 Sep 2006 14:39:36 -0400
Message-ID: <bf2f74740609281139x74e45412hd0f197128a62994@mail.gmail.com>


I have a document processing system on Oracle 10.2 Linux. It stores document as blob in the database. We store 1 Million docs a month and current table size is 5 million. Database size is 50 GB out of which blob table takes 35 GB. (It is not partitioned).

We are facing administrative issues with the size. E.g we had to move to 64 bit system from 32 bit using export import. It took a while to finish. Doing a export import for development/test databases is getting cumbersome.

I am considering moving blobs to filesystem. This will reduce the database size by 70%, reduce backup time, export/import time.

What could be challenge in storing it on file system? Any major disadvantage that I should not consider it at all?

Thanks

Sandeep

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 28 2006 - 13:39:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US