My application (classic asp yay!) has about 2.1 million images @ 25GB and that only represents 90 days of data and I'd like to go 365 at a minimum. I need to get these under control and am considering all options. What are your thoughts on the pros and cons of the following practices:
- SQL Server Pros: Easy to back up Cons: Performance ?
- File System Pros: Speed Cons: Redundancy, Back up is slow (currently researching doing Synthetic full back ups instead which might make that better)
- S3 and the like Pros: Bandwidth is shifted from my datacenter to Amazon, virtually unlimited storage. Cons: Cost, Cost Analysis is tricky (estimating 80% of my bandwidth is images for ROI purposes), Difficult/Costly to swtich service providers should that become necessary
Does anyone else deal with the multi-million image challenge and how did you address it?