Recently I was asked to do production support on an existing software.
In summary, this system is a web service that allows you to upload a file and provides you with an identifier so that you can ask for your file later.
My concern is that the files are stored as BLOB in an Oracle database.
For the moment, the system is stable, but in the near future our business wants to upload 100.000 to 200.000 PDF per year (10 to 50 Mb each).
When it comes to the Database
Should I just care about the disk space?
Are there other aspects I should worry about?
Or should I really try to switch to file system storage?
A few additional information:
- There is no need for transactions.
- All files are unrelated.
- Files will never be updated.
- Files will stay there "forever" (5 to 10 years).
- The software needs to be updated for other reasons anyway.