I have used InfluxDB for almost a year now, I expected after releasing stable version 2.0 Flux performance problem should be resolved! Can anyone tell me why InfluxQL outperforms in the order of 100 for a simple getting raw filtered data? Is there anything that I miss? In the below, I show two simple identical queries first is with Flux which took 30 seconds and the other is InfluxQL and took 0.3 seconds.
|> range(start: 2020-11-11T00:00:00.000Z, stop: 2020-11-11T23:59:00.000Z)
|> filter(fn: ® => r["_measurement"] == “mem” and r["_field"] == “cpu”)
|> yield(name: “raw”)
SELECT mem from mem where time >= ‘2020-11-11T00:00:00.000Z’ and time < ‘2020-11-11T23:59:00.000Z’ GROUP BY *
The Flux query took 32 Seconds and the Influx took 0.5. I am using InfluxDB 2.0.2