Reading Large Data Instrumentation Comparisons

Single-large object request

(1 object out of many)

Patch	Nodes	Xpath	Total duration (s)	Query duration (s)	Service duration (s)	Object Size (KB)	Object Size #Fragments
https://gerrit.onap.org/r/c/cps/+/133482	1000	cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-devices/openroadm-device[@device-id='C201-7-13A-5A1']	0.045614959	0.023366632	0.022248327	332.997	86
	2000		0.054310303	0.035996323	0.018313980
	5000		0.144935681	0.1171711	0.027764581
	10000		0.290671549	0.260282112	0.030389437
https://gerrit.onap.org/r/c/cps/+/133511/2	1000		0.054642542	0.053553622	0.001088920
	2000		0.100691847	0.100027188	0.000664659
	5000		0.22977974	0.229137155	0.000642585
	10000		0.213588816	0.212645649	0.000943167
https://gerrit.onap.org/r/c/cps/+/133511/12	1000		0.020945751	0.016911524	0.004034227
	2000		0.030075068	0.026774606	0.003300462
	5000		0.113882515	0.108687874	0.005194641
	10000		0.100853571	0.09698906	0.003864511

Graphs:

1 object contaning all node as descendatnts

Patch	Nodes	Xpath	Total duration (s)	Query duration (s)	Service duration (s)	Object Size (KB)	Object Size #Fragments
https://gerrit.onap.org/r/c/cps/+/133482	1000	cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-device	11.77267071	0.0317837	11.74088701	332997	86006
	2000		28.45149836	0.049900806	28.401597554	665994	172006
	5000		86.97307551	0.158655949	86.814419561	1664985	430006
	10000		201.453437	0.445119103	201.008317897	3329970	860006
https://gerrit.onap.org/r/c/cps/+/133511/2	1000		0.545405404	0.2234512	0.321954204	332997	86006
	2000		0.976134445	0.417910373	0.558224072	665994	172006
	5000		2.52749303	1.087584666	1.439908364	1664985	430006
	10000		6.97774575	2.928634867	4.049110883	3329970	860006
https://gerrit.onap.org/r/c/cps/+/133511/12	1000		2.954251872	1.262556839	1.691695033	332997	86006
	2000		5.491693817	2.317822096	3.173871721	665994	172006
	5000		11.02445057	5.433378386	5.591072184	1664985	430006
	10000		25.35983212	11.69850384	13.66132828	3329970	860006

Graphs:

Patch	Nodes	Xpath	Total duration (s)	Query duration (s)	Object Size (KB)	Object Size #Fragments
https://gerrit.onap.org/r/c/cps/+/133511/12	1	cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-devices/openroadm-device[@device-id='C201-7-13A-5A1']	0.08218728	0.238155269	332.997	86
	2		0.091	0.099
	3		0.123160344	0.127104472
	5		0.180049378	0.180061298
	10		0.288247712	0.283463057
	20		0.499922612	0.487560858
	50		1.007691818	0.982501371
	100		2.344462484	2.271861401
	200		7.56794471	6.225420721
	500		17.13447188	13.833553111
	1000		15.30629109	11.866555761

Graph: