Azure storage tables vs SQL
Azure storage tables vs SQL
Azure storage tables vs SQL
Re: Azure storage tables vs SQL
SQL Azure is great when you want to work with structured data using relations, indexes, constraints, etc.
Azure storage table is great when you need to work with centralized structured data without relations and usually with large volumes.
The Price:
SQL Azure: $25.98/mo for 5GB
Storage table: $21.88/m for 175 GB (without transactions or bandwidth)
So when you store large volumes of data, storage table is a lot cheaper... think of logging for example.
The centralization:
Windows Azure is a distributed environment for servers so if you save something on one machine, others won't know about it, therefore storage table is a good solution for centralized loggins, session handling, settings or whatever (keep on mind that there is latency even in one datacenter)
The speed:
If you design it right, in many cases storage table should be faster than sql azure but it probably depends on use cases and I haven't really tested this.
Azure storage table is great when you need to work with centralized structured data without relations and usually with large volumes.
The Price:
SQL Azure: $25.98/mo for 5GB
Storage table: $21.88/m for 175 GB (without transactions or bandwidth)
So when you store large volumes of data, storage table is a lot cheaper... think of logging for example.
The centralization:
Windows Azure is a distributed environment for servers so if you save something on one machine, others won't know about it, therefore storage table is a good solution for centralized loggins, session handling, settings or whatever (keep on mind that there is latency even in one datacenter)
The speed:
If you design it right, in many cases storage table should be faster than sql azure but it probably depends on use cases and I haven't really tested this.