Thank you very much for the detail explanation and suggestions.
From the Query Inspection → Stat where it gives the processing time and the total requirement time, if the processing time is getting the data with query from database, then it looks like the main time is the transmission delay. Because processing time is in the order of 0.1 to 0.2s.
I have tested locally with mysql query command to collect same data on the server side. Time is less than 2 sec. So if the Total time is 3-4sec, then it could be the network delay.
Read about the $_interval. This auto-calculating time interval looks very useful.
Here I am using query with variables in Grafana, as follows:
datetime AS “time”,
batt_id = $BATT_ID and
cell_id = $CELL_ID
ORDER BY datetime
‘measurement’ is the table name, and ‘temperature’, ‘batt_id’ and ‘cell_id’ are fields, collecting the ‘temperature’ value from the selected batt_id-cell_id from drop-down menu.
Not sure, where I should use ‘$_interval’ here. Should it be while arranging the query from the UI? I mean instead of writing the query, selecting from query menu?