Details
-
Incident report
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
2.2.4
Description
It appears that the used query:
select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc,ns desc limit 2;
This works in many times faster:
select clock,ns,value from history_uint where itemid=786846 and clock<=1406552958 order by clock desc limit 2;
Please look the screenshots for details.
