GridDB choosing between Collection and TimeSeries containers for mixed workload design

Ask 1 (specific researched non-duplicate) question. https://stackoverflow.com/tour https://stackoverflow.com/help/how-to-ask https://stackoverflow.com/help How much research effort is expected of Stack Overflow users?

This one is a different one with different type.

"This one" This is not "one" question.

Thanks for the feedback. I’ve updated the question to focus on a single core decision (choosing the appropriate container type in a mixed workload scenario) and kept the rest as supporting context.

You’ve articulated the distinction very well. In GridDB, the choice should be guided primarily by workload patterns and query semantics, not just schema similarity. TimeSeries containers are optimized for sequential writes, timestamp indexing, and range scans, while Collection containers suit flexible queries and secondary indexing.

In mixed workloads, a hybrid design is typically more efficient than standardizing on one container type.

Thanks for your support and valid answer that strong version.