We have an InfluxDB containing more 1.1million series. Writes per second are very low. We also do few queries.
But the queries we do are pretty big and have to cover and analyze lots of data. Same for our CQ. Few, but cover lots of data.
I am thinking of moving to a new server but I have the option to get 12 cores 3.5Ghz or 40+cores 2.4Ghz or even 2.1Ghz.
So I am curious what would better in our case. When running 1 large query, is it using only 1 core or it will be able to use all 40 cores and finish even faster?
I didnt find any benchmarks of Influx performance on different kind of hardware. And the benchmarks that exist focus mostly on writes/sec that we dont care about.