I have been using regular Influx interface before and now I am trying to switch to Flux.
To me it seems like some queries that were relatively simple and fast in Influx became pretty complicated (small problem) and veeery slow (big problem) in Flux.
In Influx worked very fast (I assume the measurements were stored in some metadata file)
In Flux I replaced this with:
|> drop(columns: ["_value", “_field”])
|> group(columns: ["_measurement"], mode:“by”)
as explained in:
Still this solution takes almost 10 sec (yes, my data is very large…) which is actually a problem when integrating in Grafana (and waiting for measurements drop-down to unfold).
To me it appears as the query is basically creating a lot of tables with _value _filed pairs, and doing a lot of processing to rearange those. I am wondering if I am missing some other simple solution or is this per design? Also would it be possible, to add some queries working on metadata, as in Influx, to achieve same Performance with this types of queries?
Thanks a lot and all the best.