Hi, What is the suggested/optimised way to write queries for dashboard?
I saw better performance with native clickhouse queries compared to others.
Do we have any benchmark regarding this?
05/09/2023, 3:39 PM
queries are not efficient as they pull raw data from clickhouse and then do the processing in-memory. It works in the same way Prometheus remote-read works and it is supposed to be inefficient by design.
QueryBuilder and Clickhouse SQL queries should be much faster as they use the clickhouse engine for processing and do not bring raw data to query-service