Currently, I am overthinking my InfluxDB schema and I was wondering whats the best practice for the amount of series in one measurement. Currently my schema looks like this:
fields: value, valid
In my current schema I have up to ~35.000 different sensorIds in one measurement. I am using InfluxDB 1.8. May it will be end up with a amount of up to 1.000.000 different series per measurement.
I would like to switch to a schema like:
fields: sensorId1, sensorId2, …, sensorId100000
But I cant find any advice on the maximum amount of fields per measurement. Can you help me?
Thanks in advance,