...
Total CM Handles | Total Time | CM handles/sec | |||
---|---|---|---|---|---|
# | Before deletion | After deletion | Deleted | ||
1 | 500 | 0 | 500 | 2m 9s | 3.86 |
2 | 1,000 | 0 | 1,000 | 8m 3s | 2.07 |
3 | 2,000 | 0 | 2,000 | 32m 8s | 1.04 |
4 | 2,300 | 0 | 2,300 | 37m 58s | 1.01 |
5 | 1,000 | 500 | 500 | 5m 58s | 1.40 |
6 | 1,500 | 1,000 | 500 | 9m 46s | 0.85 |
7 | 2,000 | 1,500 | 500 | 12m 5s | 0.69 |
8 | 2,000 | 1,000 | 1,000 | 23m 33s | 0.71 |
Test Results after improvement (Commit Id : 7421c69) Use native query to delete data nodes
Total CM Handles | Total Time | CM handles/sec | Speedup | |||
---|---|---|---|---|---|---|
# | Before deletion | After deletion | Deleted | |||
1 | 500 | 0 | 500 | 11.5 s | 43.33 | 11 x |
2 | 1,000 | 0 | 1,000 | 33.7 s | 29.69 | 14 x |
3 | 2,000 | 0 | 2,000 | 1m 45s | 19.08 | 18 x |
4 | 2,300 | 0 | 2,300 | 2m 22s | 16.23 | 16 x |
5 | 1,000 | 500 | 500 | 19.6 s | 25.48 | 18 x |
6 | 1,500 | 1,000 | 500 | 27.2 s | 18.41 | 22 x |
7 | 2,000 | 1,500 | 500 | 37.8 s | 13.22 | 19 x |
8 | 2,000 | 1,000 | 1,000 | 1m 10s | 14.22 | 20 x |
...
Delete performance scenario on Nordix : (Commit id : 7421c69)
# | 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 | 1,000 |
5 | Delete 5 children with grandchildren | 222 | 232 | 225 | 300 |
6 | Delete 10 list elements with keys | 1,019 | 1,097 | 990 | 1,200 |
7 | Delete 1 large data node with many descendants: | 2,008 | 1,938 | 2,136 | 2,500 |
...