Hi & thanks for making InfluxDB!
I have 500K objects with 15 boolean properties, that are measured once per day (with timestamp T00:00:00Z). As output, I want:
- A count of all true bools graph, grouped by property, over time
- To query an object/property on a specific date
I tried loading the object id’s as tags, but quickly ran out of mem.
I tried using the object id’s as measurement names, but apparently I cannot group by over multiple measurements.
Can I use InfluxDB for this data/queries?
Or should I wait for the new time series index in 1.3?
What is the best schema design here?
It seems there is a big optimization possible: the booleans don’t change much, so theoretically I would only have to store them when they change. Not sure how to implement this in InfluxDB though.