We are working with some financial data and trying to run queries on it. Something we are noticing is that the queries don’t seem to scale linearly. When running 3h of data it takes about 800ms and the running a full day takes 40s. These queries are not doing any manipulation so this seems very odd to me.
The data is organised timestamp <2x tags> <40 x fields> I’m wondering if there are some standard things i can test to see why this is happening. Also is there something comparable to examine analyze for flux?