Has anyone had an experience storing user uploaded images in a MSSQL 2008 Database using Filegroups and Filestreams? I read a few articles that seemed to say they are a good idea because you get all the advantages of storing images on disk and in the db. For example
I have implemented this for my current project but it seems like I'm doing a lot of unnecessary work having to convert the bytes and writing them as an image. (I'm using ASP.Net MVC)
Are there any other gotchas I should be worrying about? Should I really being storing these images on the disk myself instead? Should I look into other alternatives such as Amazon AWS?