CODEWITHSUNDEEP
.netazureazure-storageazure-table-storageazure-blob-storage
Fernando Silva
Fernando Silva

Reputation: 364

Performance Azure Blob vs Azure Table

I have around 300 million text files, ranging from 50kb to 100kb that I need to read and serve on a web page.

Remarks:

On Azure Table, I would need to split some of the text files, to make sure it doesn't exceed the maximum of 64kb per column.

On Azure Blob, I would not have the problem of splitting, but would need to store a reference to them on the Azure SQL/Azure Table.

Okay, intro is done! Now, on my Azure Web App:

  1. Would be faster to read the text file from Azure Blob or from Azure Table?
  2. Would the Azure Table be able to process more requests?

Upvotes: 11

Views: 5109

Answers (2)

Andrei
Andrei

Reputation: 44550

Blob storage is better then Table storage if you want to work with files. I definitely would not want to deal with file chunks in a table. If you need to keep references to your blobs, how about combining two options and use Table storage for references? I think this would be the best in terms of performance :).

Upvotes: 6

Thiago Custodio
Thiago Custodio

Reputation: 18387

I agree with Andrei M. The best solution is blob storage with a table service or even a sql database to store reference.

Just one more thing, if you plan to search for content in those file, neither table service / blob will be good for that. If that's the case, I recommend you setup a VM with elastic search / solr and index those contents.

PS: there's also Azure Search, for that, you can give it a try too.

Upvotes: 6

Related Questions