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:
- Would be faster to read the text file from Azure Blob or from Azure Table?
- Would the Azure Table be able to process more requests?