Details
-
Type:
Bug
-
Status: Resolved (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 23.0.3, Meridian-2016.1.18, Meridian-2017.1.14, Meridian-2018.1.5
-
Fix Version/s: Meridian-2016.1.19, Meridian-2017.1.15, Meridian-2018.1.6, 23.0.4
-
Component/s: None
-
Security Level: Default (Default Security Scheme)
-
Labels:None
-
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