There aren't any other optimizations to do with the query. Regular expressions are expensive, and InfluxDB doesn't yet have an internal query optimizer.
On Thu, Oct 6, 2016 at 1:06 PM, Daniel Strøm <[email protected]> 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 > > 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/f0b6945 >> f75bf9f2c70d11de76cc66a2f7aa2e573/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 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/8b919e05-5217-401d-bc0c-04815640fa6e%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/8b919e05-5217-401d-bc0c-04815640fa6e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- 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/CALGqCvPZrerXb_guV8SJmBsxZ7DYQ3t9QYtra8_n%3DZ4bQ7PV4Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
