I’ve been using this query on InfluxV1 and InfluxV2(on compatibility endpoint) and it takes a second or two. SELECT mean("signal") * mean("fft_0001"), mean("signal") * mean("fft_0002"), mean("signal") * mean("fft_0003"), mean("signal") * mean("fft_0004"), .... mean("signal") * mean("fft_0510"), m…

I’ve tried it on a beefier machine and still the same. Tried naming all fields instead of using prefix: "fft_" and that takes even longer.

Hello @tintin , I’m not sure. I’m sorry you’re having a bad experience. I’m sharing your question with the Flux team directly and I hope someone can provide some insight. Thank you.

Hi, I think the reason might be that your query isn’t utilizing the push down optimizations. import "experimental" // Use a function wrapper so we don't have to duplicate this and it will be registered // in the runtime as two separate from calls instead of one. A potential future improvement // i…

Hi @jonathan , I tried it and unfortunately there was no noticeable improvement. The data I have is 1Hz. (1 row per second) The following two queries run in less than a second, even if the range is as long as a month select = () => from(bucket: v.defaultBucket) |> range(start: v.timeRangeStar…

I think this might be a problem with the speed of join() unfortunately. I think join is probably the best function for what you want to do since you want to join one column with many other columns, but the amount of data seems to be causing a problem. If it’s possible, do you think you can share an…

I am using OSS v2. I will try to get you the data on Monday.

Here is some data: https://we.tl/t-OipqqiF3rz Tags: device and channel. Fields: signal and fft_xxxx

Adding relevant Github issue here for history sake Performance difference between Flux and InfluxQL · Issue #18088 · influxdata/influxdb · GitHub

Query with lots of fields takes orders of magnitude higher in flux than influxql

Fluxlang

tintin January 21, 2022, 8:32am 9

@Anaisdg InfluxQL still performs better than Flux for my use case. Can you confirm what the future of InfluxQL is. I see another unanswered post here regarding the same here : InfluxQL roadmap in InfluxDB 2 (will it be deprecated?).

Topic		Replies	Views
Migrating FluxQL with multiple aggregations to Flux Fluxlang influxql , flux , performance , join	7	1538	July 9, 2021
Flux performance compared to similar influxQL query Fluxlang performance	5	596	December 9, 2022
Query performance InfluxDB 2 query , flux , performance	4	810	June 12, 2024
[URGENT] Flux vs InfluxQL Groupby Speed InfluxDB 2 flux	7	643	August 30, 2023
Why is Flux query taking time than same InfluxQL query Fluxlang influxdb , query	1	369	June 25, 2023

Query with lots of fields takes orders of magnitude higher in flux than influxql

Related topics