-1

I am new in Dynamo and I have a table that is partitioned by company id and receives news everyday related to the companies, so I just insert a new record for every news that I got using the respective company id. I would like to know if there is an easy way to know which company has the most news. I thought maybe by knowing the biggest partition, but I don't find info about this, do I have to query every company and count the items they return?

dduque
  • 338
  • 4
  • 16

1 Answers1

1

There's no way for you to know anything about the physical partitions in use by DDB. I assume AWS Engineers can find out, but it's not something they are open about.

Unless your DDB data is more than 10GB, or you've configured(used) more than 3000RCU / 1000 WCU...it's highly probable that your data is in fact in a single physical partition....regardless of the number of partition key values in that data.

100 partition key values, doesn't translate into 100 physical partitions.

Charles
  • 21,637
  • 1
  • 20
  • 44