Hi What is the suggested optimised way to write queries for

Question

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

Ankit Nayan · Answer

`promQL` 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

Ankit Nayan · Answer

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

Vishnu Teja Vallala · Answer

Thanks < Ankit Nayan>