The default MAX record size is 128 KB. We need to store user events per user ordered by time and sometime we exceeds the 128KB.
For serving the user we need to retrieve his n latest event within an time interval. e.g. Last events with 2 hours.
We are looking at the following several directions but we don’t know what performs bests
- Splitting the user events into multiple records in case we exceed the 128KB and have our logic on the top to retrieve the the data from several records.
- Using Sub-Records for the user events
- Using large types. e.g. Large Ordered List
What is the best practices for modelling such kind of use cases?