Our company is using an in-house storage system that was implemented several years ago. For some reason, we use the database as a storage mechanism for our documents. Now, this is basically a best practices question: What would be the best way for storing document? What are the pros and cons?
We're starting to believe that databases aren't really meant for document storage (file systems might be the better option). Should we instead use Oracle BFILE? BLOB? Thank you for any input you provide.