r/influxdb. Why time series databases matter - InfluxDB vs MongoDB. Influx Query Language (InfluxQL) reference | InfluxDB OSS 1.7 … You can choose Prometheus as it has a lot more integrations and features. I know you can implement sum of squares via flux as described here, but I'm worried about the performance of Flux vs regular Influx queries as mentioned here. Note: Though not required, it’s a good practice to append the language choice to the data source name. Use “heavy” functions sparingly. I noticed a pretty significant difference in performance between Flux and InfluxQL and was wondering if there is an explanation for it. So in 2.0.7 performance between InfluxQL and Flux has improved but it is still 2x slower for first query and repeating same query is much faster for InfluQL probably due some caching or something. In this technical paper, we’ll compare the performance and features of InfluxDB vs MongoDB for common time series workloads, specifically looking at the rates of data ingestion, on-disk data compression, and query performance. Is it expected for Flux queries to be significantly slower? In this technical paper, we’ll compare the performance and features of InfluxDB v1.8.0 and Graphite v1.1.7 for common time series workloads, specifically looking at the rates of data ingestion, on-disk data compression, and query performance. Many SQL engines use the EXPLAIN statement to show join order, join algorithms, and predicate and expression pushdown. Use set () instead of map () when possible. Balance time range and data precision. Continuous queries must be migrated to Flux tasks. As cardinality increases, InfluxDB insert performance drops off faster than on TimescaleDB. … Webinar: Flux and InfluxDB. Start queries with pushdowns. The most significant difference between the two major versions of InfluxDB is the query language. In the first version, with some SQL notions, InfluxQL seemed extremely simple. However, after a few uses, it was easy to see the limits of a simple transcription from a language intended for a relational database to a time-series database. User account menu. For most use cases, we believe that SQL is the right query language for a time-series database. These are the documentation for FluxQL for better reference: DEEPER INSIGHTS WITH FLUX. I compared the performance of Flux and InfluxQL by querying exactly the same data. EXPLAIN. If I remove the keep statement the 30d query execution time jumps up to close to 12s.