I want to create variables in grafana and I am querying influxdb to get the values the issue so, I would like to know which stresses the servers less when ran on a big data set:
- SHOW TAG VALUES FROM ‘measurement’ WITH KEY=tag WHERE ‘condition’
- SELECT ‘tag’ FROM(SELECT ‘tag’, ‘metric’ FROM measurement WHERE ‘condition’)
Currently I am using SHOW TAG VALUES, but the tick stack admin advised me against it saying that it consumes much more resources than the SELECT query. I would like to have more insight into this.
Thank you.