Fixed
Details
Assignee
Jesse WhiteJesse WhiteReporter
Jesse WhiteJesse WhiteSprint
NoneAffects versions
Priority
Major
Details
Details
Assignee
Jesse White
Jesse WhiteReporter
Jesse White
Jesse WhiteSprint
None
Affects versions
Priority
PagerDuty
PagerDuty
PagerDuty
Created February 28, 2019 at 5:03 AM
Updated March 21, 2019 at 5:03 PM
Resolved March 9, 2019 at 1:39 AM
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