Tuesday, April 8, 2014

General Questions about Document Manager

Is compression used when the files are  uploaded?

No. There is no compression

If 50GB worth of files are on a filesystem, does that equal 50GB in the Oracle Database?

There is a slight overhead, but it is approximatley the same as long as there are no revision to files.  File revisions are kept in the database.

If a file is deleted from document manager, does that delete the blob and the metadata associated to it?

If it is not referenced from elsewhere, yes it is removed

Is there a recommended sizing determination?

Add approx 250KB per record of both index and data tablespace for sizing

For uploading/downloading documents, is there a maximum recommended size for each file to be used in document manager?

Because of different file system implementations, it is recommended file sizes be kept below 2GB

No comments:

Post a Comment