I was looking for others thoughts on topic of saving pdf to Database or File System. Currently we save all documentation, (PDF), created by our application to Filesystem with PATH stored in Database. That way we can access a copy of the documentation readily to send copies or whatever.....
The problem is the handling of that filesystem "Archive". If you should venture into one of those folders the time the system takes to generate the directory is enormous and "hungry on resource". We are looking at hundreds of thousands of files @ 30-70kb in size.
I ask those with the experience of similar design, is it better to store the pdf in the Database or is it better to store to filesystem. I appreciate the question is a little open ended, but wondering what was the experience of others that started the way we did by saving to Filesystem then converting to Database.
Obviously Database would grow significantly, but Backups and performance may / may not be improved.
Hope question makes sense and appreciate any constructive feedback.