Akash Patel
Reputation: 199
is there any impact in performance when we need to access last sort key for any particular partition key
I am creating a dynamoDB table. I am using an custromerId as partition key and versionNumber as sort key. suppose there are 1000 versions for any particular customerId. for my use-case I always want to find out last version of any customerId. will there be any difference in performance when i want first versionNumber and when i want last versionNumber or both will take same time.
Upvotes: 1
Views: 235
Answers (1)
Sai
Reputation: 1700
No, actually we'll have a parameter ScanIndexForward (True/False). So based on this it starts reading the dynamoDB in ascending or the descending order.
Upvotes: 1
Related Questions
- How to get all the Sort keys for a given Partition key (HASH) efficiently?
- Is using json as sort key/partition key value good practice in DynamoDB?
- Impact of unique partition key on DynamoDB performance
- Do I need a sort key in DynamoDB if my partition key is unique?
- DynamoDB query performance with - a unique partition key vs a unique partition+sort key
- Should partition key or sort key in a DynamoDB single-table design only contain fields that are not likely to change?
- DynamoDB | How to Query all records in sorted order without specifying a Partition Key
- What is the difference between partition key and sort key in amazon dynamodb?
- How do I query DynamoDB when I want to consider the sort key but not the partition key?
- Does a sort key in dynamo sort even with different partition keys?