I would like to know if there is any performance impact if I use same measurement name to store similar data for different retention period.
Let us say I have a measurement named respsonsetimes. And I have two retention policies - two_months and one_week.
I have a high cardinality tag. This tag is not stored in two_months retention period. While the tag will be stored in one_week period. Rest of the tag/field values are same between two retention policies.
Can some one suggest if this is a bad choice? Should I use a different measurement name for two retention period data’s?
Please share your opinions.