I have a public partition in which data is structured as
_id task userId
1 task1 User1
2 task2 User2
.................
I need to fetch and sync data based on userId.
Partition by userId is an option,but i don't want this.
Use Case: Take a example of Chat App where users can interact One to One and in a group.
My Findings: I need three type of partition
A. based on user id (user specific)
B. based on conversation id (conversation specific)
C. public (has user info)
My Doubt:
Suppose i have 10 contacts and public partition has 100 users,how do i get only contact specific list and sync.(Docs suggests you will get all data of a partition)
Suppose my user base increases to 100 thousands,I have to maintain 100 thousands partitions and same for conversations.
I Want
Maintain a collection has user and conversation table/schema. Fetch and sync data using User id.