- Requirement1: Query all group conversations a user participates in after a given timestamp.
- Requirement2: For each conversation, load all messages within that conversation created later than a given timestamp.
- Requirement3: For each conversation, load all participates inside it.
- In group chat scenario (Except for those extremely big 100K+ groups -_-), typically read write ratio will be 100:1. So the storage model should better balance this factor to something like 50:50 or more evenly. So typically write amplification is used.
