De-Register CM Handles (Removed CM Handles)

Test Configurations

#	Environment/Workload	Description
1	Tested on	laptop : Processor : Intel© Core™ i7-8750H CPU @ 2.20GHz × 6 Installed RAM : 32.0 GB Edition : Linux Mint 21.1
2	Docker-compose	Docker-compose file: https://gerrit.onap.org/r/gitweb?p=cps.git;a=blob_plain;f=docker-compose/docker-compose.yml;hb=aa29f24b0da9b9d2c86a0c528357a17ff3d7a871
3	cURL	De-Register CM Handles cURL Expand source
4	Number of CPS Instance	1
5	Number Modules per Cm Handle	10
6	Commit ID (before improvement)	9c56b30 Fetch CM handles by collection of xpaths
7	Commit ID (after improvement)	7421c69 Use native query to delete data nodes

#	Component	Configuration Parameters	Value
1	CPS	notifactions:enabled	true
2	CPS	config.additional.notification.data-updated.filters.dataspaces.enabled-dataspaces	"NON-EXISTING-DATASPACE"
3	NCMP	modules-sync-watchdog:async-executor:parallelism-level	10

...

Total CM Handles				Total Time	CM handles/sec	Speedup
#	Before deletion	After deletion	Deleted	Total Time	CM handles/sec
1	500	0	500	11.5 s	43.33	11 x
2	1000	500	500	19.6 s	25.48	18 x
3	1500	1000	500	27.2 s	18.41	22 x
4	2000	1500	500	37.8 s	13.22	19 x
5	1000	0	1000	33.7 s	29.69	14 x
6	2000	1000	1000	1m 10s	14.22	20 x
7	2000	0	2000	1m 45s	19.08	18 x
8	2300	0	2300	2m 22s	16.23	16 x

Spreadsheet:

View file

name	Performance of CM Handle Deregistration.odsxlsx
height	250

#	Test Scenario	Nordix Build 1 (ms)	Nordix Build 2 (ms)	Nordix Build 3 (ms)	Groovy test deleteDurationInMillis (ms)
1	Delete root node with many descendants	165	168	166	200
2	Delete data nodes for an anchor	172	210	169	250
3	Delete 50 grandchildren (that have no descendants):	304	232	263	350
4	Delete 5 whole lists with many elements	796	852	758	1000
5	Delete 5 children with grandchildren	222	232	225	300
6	Delete 10 list elements with keys	1019	1097	990	1200
7	Delete 1 large data node with many descendants:	2008	1938	2136	2500