I wanted to know the performance differences between Flux and InfluxQL in a scaled setup that has around 10,000 instances of telegraf pushing data every minute and also data being accessed for the time range of 2-3 months.So, which of flux or influxql will help me access data in the specified range at a much faster rate and without causing any OOM issue?
Here is a sample query that i want to run:
select count(uptime) from system where time > now() - 90d group by deviceid
P.S. - i am running influxdb 1.8 as a docker