That made it prettier, and actually somewhat faster too. We'll go with that for now! Thanks.
On Wed, Oct 5, 2016 at 12:54 AM Sean Beckett <[email protected]> wrote: > 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/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 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 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/CALGqCvOBbePL9j225N5XBZs9voYEPWz1dWUHyszFqtNj-%2Bnrpg%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CALGqCvOBbePL9j225N5XBZs9voYEPWz1dWUHyszFqtNj-%2Bnrpg%40mail.gmail.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_11WM_P_a-jncGBSv0bU%2BhtqPY1wLUKHPN9jw16VWX6wA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
