Speed problem in rendering of multiple chart panels

Grafana Dashboards
1

Hello,

If all 5 dashboard contains same dynamical chart panels and contains same query then why some dashboard charts panel take some time in rendering ( like SQL-1) contains 50 rows of chart panel while some are take less number of rendering time (SQL-2) contains 150 rows of chart panel even they have similar queries and charts panel and same data source and retrieving data from same tables if everything is identically same.

Then where is the issue the queries are fully optimized.

2

what datasource are you using? mysql, mssql?

3

MSSQL as a data source we used

4

are you using inline queries or stored procedures. can you post some sample queries