Azure的表或SQL Azure的？ [英] Azure Tables or SQL Azure?

问题描述

我在将在Azure中使用ASP.NET主办的网站提供丰富的用户体验中的网站和Silverlight Web应用程序的规划阶段。我应该使用Azure的表或SQL Azure的存储我的应用程序的数据？

I am at the planning stage of a web application that will be hosted in Azure with ASP.NET for the web site and Silverlight within the site for a rich user experience. Should I use Azure Tables or SQL Azure for storing my application data?

推荐答案

天青表的存储似乎比SQL Azure的便宜。它也比SQL Azure的更高度可扩展的。

Azure Table Storage appears to be less expensive than SQL Azure. It is also more highly scalable than SQL Azure.

SQL Azure是更容易使用，如果你已经做了很多关系数据库的工作工作。如果你移植一个已经使用SQL数据库，然后将其移动到SQL Azure的将是显而易见的选择一个应用程序，但是这是唯一的情况下，我会推荐它。

SQL Azure is easier to work with if you've been doing a lot of relational database work. If you were porting an application that was already using a SQL database, then moving it to SQL Azure would be the obvious choice, but that's the only situation where I would recommend it.

在Azure上表的主要限制是缺乏二级索引。这是在PDC '09宣布，目前列为即将推出，但一直没有任何时限公告。 （请参阅http://windowsazure.uservoice.com/forums/34192-windows-azure-feature-voting/suggestions/396314-support-secondary-indexes?ref=title)

The main limitation on Azure Tables is the lack of secondary indexes. This was announced at PDC '09 and is currently listed as coming soon, but there hasn't been any time-frame announcement. (See http://windowsazure.uservoice.com/forums/34192-windows-azure-feature-voting/suggestions/396314-support-secondary-indexes?ref=title)

我见过的建议使用在您使用表和Blob存储的大容量数据的混合动力系统，而是使用SQL Azure中的索引，搜索和过滤。但是，我还没有机会尝试这种解决办法还没有我自己。

I've seen the proposed use of a hybrid system where you use table and blob storage for the bulk of your data, but use SQL Azure for indexes, searching and filtering. However, I haven't had a chance to try that solution yet myself.

一旦二级索引添加到表存储，它实际上都是基于云的NoSQL 系统将大大更有用的比现在。

Once the secondary indexes are added to table storage, it will essentially be a cloud based NoSQL system and will be much more useful than it is now.

这篇关于Azure的表或SQL Azure的？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！