Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-10589

Poor performance when using filters in the Measurements API

    XMLWordPrintable

    Details

    • Sprint:
      Horizon - Feb 27th 2019, Horizon - March 6th 2019

      Description

      While diagnosing a performance issue with the Measurements API reported here: https://opennms.discourse.group/t/filter-measurement-api-incredibly-slowish-and-unuseable/230/3

      I found that the bottleneck is the following routine:
      https://github.com/OpenNMS/opennms/blob/08156f656ef0edf3c2756af71b25c7f7a640a118/features/measurements/api/src/main/java/org/opennms/netmgt/measurements/api/FetchResults.java#L99

      Processing a result set with 500 values takes 0.5 seconds, 5k values takes 25 seconds, 10k values takes 96 seconds, and so on...

      I found a botte

        Attachments

          Activity

            People

            • Assignee:
              j-white Jesse White
              Reporter:
              j-white Jesse White
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: