@Mathias: Yes, i'm only fetching one data-point pr. vehicle, which is the mean of all the data-points in that timespan.
On Thu, Oct 6, 2016 at 10:37 PM Mathias Herberts <[email protected]> wrote: > If I understand you query correctly you are fetching a single datapoint > per series (time >= '2016-09-06 21:05:40' AND time <= '2016-10-06 > 21:05:40'), so your MEAN computation either operates on a single series, > which kinda defies the point, or on multiple series with identical value > for tag 'vehicle'. > > In the first case it seems to me your query is equivalent to fetching a > single datapoint from 300 series, right? > > On Thursday, October 6, 2016 at 9:06:58 PM UTC+2, Daniel Strøm wrote: > > So, a question on this. I've created a 1 day rollup of some queries. Now i > have a query looking like this: > https://gist.github.com/Danielss89/791bcd74fce00848dac2ac1d270f2e2e > <https://www.google.com/url?q=https%3A%2F%2Fgist.github.com%2FDanielss89%2F791bcd74fce00848dac2ac1d270f2e2e&sa=D&sntz=1&usg=AFQjCNH_ID-urTpomMSuYeeTd0LoaCciKw> > > The query takes around ~1s, which is a lot more that i would expect. > MySQL do this in 0.03 seconds. > > Do you have any tips on how to make this perform better? > > Thanks > Daniel > > On Tuesday, October 4, 2016 at 11:10:53 PM UTC+2, Daniel Strøm wrote: > > Hi > > I've just started using InlufxDB, so this might be a dumb question, > anyway, here goes: > > I have a query looking like this: > https://gist.githubusercontent.com/Danielss89/b84c91b6890b61d57b80bd3e64343d8b/raw/f0b6945f75bf9f2c70d11de76cc66a2f7aa2e573/gistfile1.txt > and yes, that is quite a lot of vehicle = xxx's. > > Does InfluxDB have some sort of "IN" which is faster, or what can i do to > make this perform better? > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to a topic in the > Google Groups "InfluxDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/influxdb/IwLWQ9ERGDU/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/f0c89bc8-9239-412c-b631-e89125451de4%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/f0c89bc8-9239-412c-b631-e89125451de4%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CAFYC4_1dkCecXB-4v%2BYfauS__Kq15JaVCEsgxtQTafXiwaGdtg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
