Page History

...

Test Results after improvement 7421c69 Use native query to delete data nodes

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
21000	1,000	01000	1,000	33.7 s	29.69	14 x
32000	2,000	02000	2,000	1m 45s	19.08	18 x
42300	2,300	02300	2,300	2m 22s	16.23	16 x
51000	1,000	500	500	19.6 s	25.48	18 x
6	1500	1,500	1,0001000	500	27.2 s	18.41	22 x
7	2000	2,000	1,5001500	500	37.8 s	13.22	19 x
8	2000	1000	2,000	1,000	1,0001000	1m 10s	14.22	20 x

Spreadsheet:

...

#	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	7581000	1,000
5	Delete 5 children with grandchildren	222	232	225	300
6	Delete 10 list elements with keys	1019	1,019	1,0971097	9901200	1,200
7	Delete 1 large data node with many descendants:	2008	1938	2136	2,008	1,938	2,136	2,5002500

View file

name	Performance of CM Handle Deregistration.xlsx
height	250