Optimize the "most recent" type queries

XMLWordPrintable

    • 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).

            Assignee:
            Matt Magoffin
            Reporter:
            Matt Magoffin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: