Cosmos db Data in Single container vs multiple Container due to high Volume

Question

Hi Everyone -

I have a Login table (with Mobile Number (Row Key), App Type (Partition Key) OTP, OTP Timer etc ( < 10 fields).

I will be having almost 100 million records.

The question is -

1. Do i need to Store all of this in One Container in Cosmos DB or
2. Do I need to Put in Multiple Container (based on Partition Key which is my App Type)

Note:- I will be having around 20 Apps. I will be using a Database Shared throughput of Rus.

Any thoughts ?

Thanks in Advance!
-Mathew James

Answer 1

PartitionKey is a part of the container, so you should use a single container which is partitioned how ever you require.

Assuming all apps create an equal volume of login requests - then AppId sounds reasonable as a partition key.

https://learn.microsoft.com/en-us/azure/cosmos-db/resource-model#azure-cosmos-db-containers