Host Audio & Images in Azure or database as BLOBS?

Question

User-78632608 posted

I have read many threads on this and I am still not sure which one to do.

My application is going to be a music site, which obviously means a lot of data in audio files.
At the moment I am saving the audio and images to the database in binary. These are taking up a lot of space though. Would I be better off switching to hosting the files on Azure or something else?

Thanks.

Answer 1

User-646145796 posted

Hi,

From my experience, it is a good idea to save static resource in azure Blob. Azure storage provide bandwidth, refer to https://azure.microsoft.com/en-us/documentation/articles/storage-performance-checklist/#subheading16 for more details. Such as when a user request an Audio or Image, Azure storage will provide this static resource. In this way can reduce the pressure on the application server. If you develop this application, we can monitor the bandwidth in Azure portal “MONITOR” tab (Monitor a storage account in the Azure ). In addition, Azure storage is cheaper than Azure SQL database usually. For the pricing of Azure storage, please refer to https://azure.microsoft.com/en-us/pricing/details/storage/. For the pricing of Azure database, please refer to https://azure.microsoft.com/en-us/pricing/details/sql-database/?b=16.50. 

Best Regards,

Jambor

Answer 2

User-78632608 posted

So I presume for dynamic resources you would go with DB?

Also, what would be a dynamic resource? 

Answer 3

User-646145796 posted

Hi,

For the concept about Dynamic resource and Static resource, please refer to this thread: https://social.msdn.microsoft.com/Forums/vstudio/en-US/175070f3-058e-4767-ac9d-25a612757aa1/what-is-the-difference-between-static-resource-and-dynamic-resources-when-should-each-be-used?forum=wpf.  As I know, we have two choice to save our dynamic resource in azure. 1) Azure Table Storage 2) Azure SQL Database. please have a look at this thread to know the difference about them: https://msdn.microsoft.com/en-us/magazine/gg309178.aspx. 

Best Regards,

Jambor