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 in Azure by sabby
• 4,350 points
39 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 by Perry
• 17,020 points

Related Questions In Azure

+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
• 56,940 points
849 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
313 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 in Azure by Archana
• 5,560 points
32 views
0 votes
2 answers
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
422 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
• 56,940 points
74 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
1,952 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 in Azure by Prerna
• 1,940 points
589 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 in Azure by Perry
• 17,020 points
217 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 in Azure by Perry
• 17,020 points
1,134 views