Azure table storage design for simple social networking

What is the best table design if I want to use Azure Table Service for a simple social networking website?

  1. The website could have millions of users.
  2. Users need to be able to view a list of all other users in the system sorted by the number of mutual connections.
  3. Users must be able to view a list of their connections
  4. User must be able to view content posted by themselves and their connections.

One major design constraint is that Azure table service queries are generally limited to the partition key and row key when there are a large number of records or else they get really slow. Another constraint is that query results are only sorted by the partition key and then the row key.


  • Edited by Xethnic Saturday, January 24, 2015 8:28 PM
January 24th, 2015 8:07pm
The table design guide should help http://azure.microsoft.com/en-us/documentation/articles/storage-table-design-guide/
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2015 10:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics