I have an ASP.Net MVC website running on a shared IIS7 host that allows users to create their own landing page. The website allows users to edit the content, style (edit css via a UI) as well as uploading images.
I am considering migrating to Windows Azure to improve scalability and improve database backups (using SQL Azure Data Sync see http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-backup-and-restore-strategy.aspx, I am limited in the SQL backup plans offered with my host)
One stumbling block is, since the clients can upload images and edit css files, these files will need to be stored in the blob storage or the database (any other options?). I don't want to use the database because database storage as it is more expensive.
However, if these files are stored in blob storage, how will this impact the performance of the website given the files (css, images) are fetched from the blob storage instead of being read from the same disk as the website? I know browser caching will reduce the requests for these files, but what about first time requests?