php - How can I get the total number of items in a DynamoDB table? - Stack Overflow

php - How can I get the total number of items in a DynamoDB table? - Stack Overflow

up vote 3 down vote accepted

I can think of three options to get the total number of items in a DynamoDB table.

1. 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.

2. 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.

3. 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