-
Type:
Improvement
-
Resolution: Fixed
-
Priority:
Major
-
Component/s: DB, SolarQuery
-
None
The SQL queries that return the "most recent" data for groups of node IDs can be a bit on the slow side sometimes, according to some log analysis. These queries are used frequently, such as when servicing "stale datum" alerts. Try to optimize them a bit more to get their worst case execution time down (have seen 30s+ times).