Regex is the answer. It will be somewhat slow, but it will work. 300 concatenated "OR" clauses will likely lead to RAM issues.
On Tue, Oct 4, 2016 at 3:52 PM, David Neuman <[email protected]> wrote: > I think you could use a regex which would make things shorter...something > like: AND vehicle =~ /305|91|123|456|789/ > That is how I usually do INs. > > On Tuesday, October 4, 2016 at 3:10:53 PM UTC-6, 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/2285ea6f-de46-4adb-8502-82f64293a38d%40googlegroups.com > <https://groups.google.com/d/msgid/influxdb/2285ea6f-de46-4adb-8502-82f64293a38d%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/CALGqCvOBbePL9j225N5XBZs9voYEPWz1dWUHyszFqtNj-%2Bnrpg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
