Large key store in Sql Azure
We want to store a large key value pair set in Sql Azure (about 50GB) consisting of an MD5 hash key and an int value. The table will not be written after it is full and will be requested frequently. The queries will run for multiple keys ranging from 6 to 5000 items at a time. Are there any better practices that we should follow, such as: can we query using IN, should queries be truncated into smaller sections more? Everything we need to know.
source to share
How complex are your queries? Perhaps you can consider alternatives to SQL Server.
Azure storage tables - noSQL key vault is great for storing large amounts of data, fairly fast for queries with section key and row key, and cheap comparison to SQL. If you can do good partitioning and data extraction (6-5000 items) into whole sections, you're done. See Comparison to SQL: https://msdn.microsoft.com/en-us/library/azure/jj553018.aspx
DocumentDB is another unstructured noSQL storage that is more indexed and more queryable than Azure Tables. http://azure.microsoft.com/en-us/services/documentdb/
source to share