question

SonaliSingh8-1999 avatar image
0 Votes"
SonaliSingh8-1999 asked AnuragSharma-08 commented

Storage architecture of Azure Table Storage

Is the data stored within each partition in sequential order i.e. in ascending order of RowKey value?
If yes, then who does this assignment in the servers?
Also, is there any link which describes the entire architecture of how the assignment is done at the backend?

azure-table-storage
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SonaliSingh8-1999 , just wanted to check if you need any other information. If answer helped, you can mark it as 'Accept Answer'

0 Votes 0 ·

1 Answer

AnuragSharma-08 avatar image
1 Vote"
AnuragSharma-08 answered sadomovalex commented

Hi @SonaliSingh8-1999 , welcome to Microsoft Q&A forum.

The primary key for an Azure entity consists of the combined PartitionKey and RowKey properties. The two properties form a single clustered index within the table. The clustered index sorts by the PartitionKey in ascending order and then by RowKey in ascending order. Because a table has only one index, query performance usually is related to the PartitionKey and RowKey properties.

I would suggest you to go through the below article that has detailed information about the same:

Design a scalable partitioning strategy for Azure Table storage

Please let me know if this helps or else we can discuss further.


Please don't forgot to click on accept it as answer button 138749-image.png wherever the information provided helps you. This can be beneficial to other community members as well.



image.png (7.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

so basically it means yes within the same partition items are sorted by RowKey in ascending order

0 Votes 0 ·