Document Stored in file directories not the database
We are starting to have considerable problems with supporting databases of clients that have heavily adopted the uses of document management. This is giving us almost unmanageable size databases with 90% of the database size just documents. we have a 65Gb database with 55Gb of documents. I feel there is a definite need to review how documents are managed and look to store within files that are far more manageable and designed for storage of this kind and leave the data for data. if a method is identified an option should be created to move the current docs out, maybe swap with url links.
Ashley Nuttall
shared this idea
-
Mihkel Metsala
commented
Our clients have started to ask for the same option to store documents outside of the database in order to avoid many problems that come with the current solution.
-
Steve Harwood
commented
I'm not sure if your original idea was to use cloud storage but I'd like to see that as one of the options too since it would just be a different link (file:// vs. s3:// vs. blob://)
Having that integration option could be opened up to other parts of the system to do some archival or offloading as well