feat: Flux Sorted Pivot perf test

influxdata / influxdb-comparisons

Code for comparison write ups of InfluxDB and other solutions

MIT License

307 stars 112 forks source link

feat: Flux Sorted Pivot perf test #190

Closed serenibyss closed 3 years ago

serenibyss commented 3 years ago

Perf test for https://github.com/influxdata/influxdb/issues/22016.

The performance data I gathered:		max	mean
InfluxQL (1.8)	4.29ms	0.26ms
Flux (2.x)	19.39ms	14.03ms

This data is not completely fair, since the pivot() function does not exist in InfluxQL as stated here, but since InfluxQL will pivot automatically, it should still be a valid test.

serenibyss commented 3 years ago

Addressed requested changes, and updated the benchmarking results table in the opening comment.

serenibyss commented 3 years ago

Not really sure why these types of errors are even running at all in the query running but, fixed them and updated the table once more.