I am designing a database schema for a project but I can’t chose between two different options.
In short,
I have 16 leaching columns setup, each with about 20 sensors for temp, pH, flow etc.
Should I store each sensor in its own field e.g. temp=24.5, pH = 4.2 timestamp
or
Create a tag for that field e.g.
sensor = temp value = 24.5 timestamp
sensor = pH value = 4.2 timestamp
What is better for long term influx performance?