There's an old discussion whether and application should store its files in a database or in the filesystem. Both have their pros and cons.
I want to know if there's any specific system for application file storage than can overcome some of the drawbacks of filesystems and databases.
Example:
In a web application that's going to handle about 100K records per year with some (2 to 5) scanned files per record.
- Databases usually have a performance hit when handling large number of blobs
- Filesystems usually have problems handling a large number of files in the same directory, and I don't want to care about handling subfolders.
Are there specific file storage systems that are good in a scenario like this one?