CODEWITHSUNDEEP
amazon-dynamodbnosql
Costa Michailidis
Costa Michailidis

Reputation: 8178

Does a sort key in dynamo sort even with different partition keys?

Getting acclimated to DynamoDB : )

If I have a table with a unique partition key, like a unique id, and I use a time stamp as a sort key, how will Dynamo sort my data?

Will I have the most recent things in one partition, and the older things in other partitions?

I ask because I want to know how to assign throughput, and I'm certain my recently created and edited items will be most likely to be accessed, and the old stuff can pretty much be archived.

Upvotes: 2

Views: 825

Answers (1)

notionquest
notionquest

Reputation: 39186

Dynamodb keeps all the items of a particular partition key in one partition. For eg, if there are 10 items available for a specific partition key with different timestamps, all the 10 items will be present on single partition. So that when the data is retrieved for a partition key, all the items can be retrieved from single partition. This makes the retrieval process faster.

Reg the sorting, Dynamodb sorts the data for the particular partition key. You can use the ScanIndexForward parameter to sort the data by ascending or descending order.

Upvotes: 2

Related Questions