Setup
Environment:
OS: Zorin OS 16.2
RAM: 32 GB
CPU: Intel® Core™ i7-10610U CPU @ 1.80GHz × 8
Data:
Included in ZIP file (at bottom)
- All data under 1 anchors
- Under
/openroadm-deviceswe have list of 10,000openroadm-device[..]
- Under
- tree-size per 'device' fragments 86 fragments
- KB per devices: 333 KB
Single-large object request
Query: cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-devices/openroadm-device[@device-id='C201-7-13A-5A1']
Durations are average of 100 measurements
(1 object out of many)
| Patch | Devices | E2E duration (s) | Fragment Query duration (s) | Service Overhead | Graph |
|---|---|---|---|---|---|
1) Baseline | 1,000 | 0.045 | 0.023 | 0.022 |
|
| 2,000 | 0.054 | 0.035 | 0.018 | ||
| 5,000 | 0.144 | 0.117 | 0.027 | ||
| 10,000 | 0.290 | 0.260 | 0.030 | ||
| 2) https://gerrit.onap.org/r/c/cps/+/133511/2 | 1,000 | 0.054 | 0.053 | 0.001 |
|
| 2,000 | 0.100 | 0.100 | 0.000 | ||
| 5,000 | 0.229 | 0.229 | 0.000 | ||
| 10,000 | 0.213 | 0.212 | 0.000 | ||
3) https://gerrit.onap.org/r/c/cps/+/133511/12 | 1,000 | 0.020 | 0.016 | 0.004 |
|
| 2,000 | 0.030 | 0.026 | 0.003 | ||
| 5,000 | 0.113 | 0.108 | 0.005 | ||
| 10,000 | 0.100 | 0.096 | 0.003 |
Observations (patch 3)
- Is 'findByAnchorAndCspPath' being used (shouldn't?!)
- Query time increases until list-size reached 6,000 elements and then levels off
Whole data tree as one request
1 object containing all node as descendants
Query: cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-device
All queries ran 10-reames
| Patch | Devices | E2E duration (s) | Fragment Query duration (s) | Service duration (s) | Object Size (KB) | Object Size #Fragments | Graph |
|---|---|---|---|---|---|---|---|
1) Baseline | 1,000 | 11.8 | 0.031* | 11.740 | 333 | 86,000 |
|
| 2,000 | 28.5 | 0.049 | 28.401 | 666 | 172,000 | ||
| 5,000 | 87.0 | 0.158 | 86.814 | 1,664,985 | 430,000 | ||
| 10,000 | 201.0 | 0.445 | 201.008 | 3,329,970 | 860,000 | ||
2) | 1,000 | 0.5 | 0.223 | 0.321 | 332,997 | 86,000 |
|
| 2,000 | 1.0 | 0.417 | 0.558 | 665,994 | 172,000 | ||
| 5,000 | 2.5 | 1.087 | 1.439 | 1664985 | 430,000 | ||
| 10,000 | 7.0 ??? Was this wrong ?! | 2.928 | 4.049 | 3329970 | 860,000 | ||
| 1,000 | 3.0 | 1.262 | 1.691 | 332997 | 86,000 |
| |
| 2,000 | 5.5 | 2.317 | 3.173 | 665994 | 172,000 | ||
| 5,000 | 11.0 | 5.433 | 5.591 | 1664985 | 430,000 | ||
| 10,000 | 25.4 | 11.698 | 13.661 | 3329970 | 860,000 |
*Only initial Hibernate query
**
Observations:
Get nodes parallel
Query: cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-devices/openroadm-device[@device-id='C201-7-13A-5A1']
| Patch | Threads | E2E duration (s) | Fragment Query duration (s) |
|---|---|---|---|
| https://gerrit.onap.org/r/c/cps/+/133511/12 | 1 | 0.082 | 0.238 |
| 2 | 0.091 | 0.099 | |
| 3 | 0.123 | 0.127 | |
| 5 | 0.180 | 0.180 | |
| 10 | 0.288 | 0.283 | |
| 20 | 0.499 | 0.487 | |
| 50 | 1.007 | 0.982 | |
| 100 | 2.344 | 2.271 | |
| 200 | 7.567 | 6.225 | |
| 500 | 17.134 | 13.833 | |
| 1000 | 15.306 | 11.866 |
Graph:
