Azure Table or SQL Azure for storing app data.

0 votes
I am developing a Web App that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a better user experience. I had a query regarding whether I should use Azure Tables or SQL Azure for storing my application data?
Jul 8, 2019 in Azure by sabby
• 4,370 points
92 views

1 answer to this question.

0 votes

Azure tables are cheaper, simpler and scale better than SQL Azure. SQL Azure is a managed SQL environment, multi-tenant in nature, so you should analyze if your performance requirements are fit for SQL Azure. 

You can consider the following points to decide: 

  • Do you need to do complex joins and use secondary indexes? If yes, SQL Azure is the best option.
  • Do you need stored procedures? If yes, SQL Azure.
  • Do you need auto-scaling capabilities? Azure tables is the best option.
  • Rows within an Azure table cannot exceed 4MB in size. If you need to store large data within a row, it is better to store it in blob storage and reference the blob's URI in the table row.
  • Do you need to store massive amounts of semi-structured data? If yes, Azure tables are advantageous.
answered Jul 8, 2019 by Perry
• 17,090 points

Related Questions In Azure

0 votes
1 answer

Where i can see the monitoring data in Azure? Can we get that data locally in SQL or NoSQL?

You can check the logs for the ...READ MORE

answered Jun 30 in Azure by Shivangi Namgyal
56 views
+1 vote
2 answers

Getting an App pool timeout for azure web sites

Windows Azure Web Sites supports two modes, ...READ MORE

answered Aug 21, 2018 in Azure by Priyaj
• 57,550 points
1,567 views
0 votes
1 answer

How can we connect Azure Web App to an Azure SQL Database?

Its easy now! Go to your Azure SQL ...READ MORE

answered Aug 8, 2018 in Azure by club_seesharp
• 3,450 points
1,893 views
0 votes
1 answer

Which is better: Azure Blob or Azure Table?

The best solution is blob storage with ...READ MORE

answered Mar 5, 2019 in Azure by Archana
• 5,600 points
71 views
0 votes
4 answers

How can I rename a SQL Azure database?

This command serves the purpose ALTER DATABASE [oldname] ...READ MORE

answered Nov 30, 2018 in Azure by Abhinav
731 views
0 votes
1 answer

Which cloud hosting is best ( AWS or Azure or Google)

Hello @Hammer, This totally depends on your needs, ...READ MORE

answered Aug 10, 2018 in AWS by Priyaj
• 57,550 points
191 views
+14 votes
23 answers

AWS vs Azure which one will have a more promising career?

Azure is integrating with a lot of ...READ MORE

answered Jul 4, 2018 in Career Counselling by Soumodip Sinha
4,074 views
0 votes
1 answer

Azure has 3 different types of storage accounts. Is there any major difference between them?

Azure Storage provides three types of storage ...READ MORE

answered Mar 4, 2019 in Azure by p
• 1,940 points
3,888 views
0 votes
1 answer

Configure Windows Azure For URL rewrite using WordPress.

You need to understand that the configuration is ...READ MORE

answered Jun 28, 2019 in Azure by Perry
• 17,090 points
1,234 views
0 votes
1 answer

How to register new users for MVC4 website on Azure AD?

The application holds the permissions to read/write ...READ MORE

answered Jul 3, 2019 in Azure by Perry
• 17,090 points
1,223 views