php - How can I get the total number of items in a DynamoDB table? - Stack Overflow
I can think of three options to get the total number of items in a DynamoDB table.
The first option is using the scan, but the scan function is inefficient and is in general a bad practice, especially for tables with heavy reads or production tables.
The second option is what was mention by Atharva:
A better solution that comes to my mind is to maintain the total number of item counts for such tables in a separate table, where each item will have Table name as it's hash key and total number of items in that table as it's non-key attribute. You can then keep this Table possibly named "TotalNumberOfItemsPerTable" updated by making atomic update operations to increment/decrement the total item count for a particular table.
The only problem this is that increment operations are not idempotent. So if a write fails or you write more than once this will be reflected in the count. If you need pin-point accuracy, use a conditional update instead.
The simplest solution is the DescribeTable which returns ItemCount. The only issue is that the count isn't up to date. The count is updated every 6 hours.
Read full article from php - How can I get the total number of items in a DynamoDB table? - Stack Overflow
No comments:
Post a Comment