We are evaluating InfluxDB as a possible time series datastore. We have a use case where instead of storing many tags at a measurement level, we want to store a single tag (device id) at the measurement level and then have a separate table/datastore to store a time-phased mapping between device and a device level tag (eg. location, vertical, etc.). This is because our customers can change these device level tags dynamically.
See https://www.xaprb.com/blog/2015/10/16/time-series-tagging/ for a better explanation of what we would like to do.
Our initial goal to be able support 10,000 devices. What would be recommended approach? A huge OR clause? Is this even practical?
Any advice is appreciated.