Images in database vs file system
- by Jesse
We have a project coming up where we will be building a whole backend CMS system that will power our entire extranet and intranet with one package. The question I have been trying to find an answer to is which is better: storing images in the database (SQL Server 2005) so we may have integrity, single replication plan, etc OR storing on the file system?
One issue we have is that we have multiple servers load balanced that require to have the same data at all times. As of now we have SQL replication taking care of that but file replication seems to be a little tougher. Another concern we have is that we would like to have multiple resolutions of the same image, we are not sure if creating and storing each version on the file system would be best or maybe dynamically pulling and creating the resolution image we would like upon request.
Our concerns are the with the following:
Data integrity
Data replication
Multiple resolutions
Speed of database vs file system
Overhead load of database vs file system
Data management and backup
Does anyone have a similar situation or have any input on what would be recommended? Thanks in advance for the help!