...
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 | 10001,000 | 0.045 | 0.023 | 0.022 |
|
| 2,0002000 | 0.054 | 0.035 | 0.018 | ||
| 50005,000 | 0.144 | 0.117 | 0.027 | ||
| 1000010,000 | 0.290 | 0.260 | 0.030 | ||
| 2) https://gerrit.onap.org/r/c/cps/+/133511/2 | 10001,000 | 0.054 | 0.053 | 0.001 |
|
| 20002,000 | 0.100 | 0.100 | 0.000 | ||
| 50005,000 | 0.229 | 0.229 | 0.000 | ||
| 1000010,000 | 0.213 | 0.212 | 0.000 | ||
| 1,0001000 | 0.020 | 0.016 | 0.004 |
|
| 20002,000 | 0.030 | 0.026 | 0.003 | ||
| 50005,000 | 0.113 | 0.108 | 0.005 | ||
| 1000010,000 | 0.100 | 0.096 | 0.003 |
Graphs:
ttps://gerrit.onap.org/r/c/cps/+/133482:
https://gerrit.onap.org/r/c/cps/+/133511/2:
https://gerrit.onap.org/r/c/cps/+/133511/12:
Conclusions:
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
...
Query: cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-device
All queries ran 10-reames
| Patch | NodesDevices | Total E2E duration (s) | Fragment Query duration (s) | Service duration (s) | Object Size (KB) | Object Size #Fragments |
|---|---|---|---|---|---|---|
| https://gerrit.onap.org/r/c/cps/+/133482 | 1,000 | 11.8 | 0.031* | 11.740 | 332,997333 | 86,006000 |
| 2,000 | 28.5 | 0.049 | 28.401 | 665,994666 | 172,006000 | |
| 5,000 | 87.0 | 0.158 | 86.814 | 1,664,985 | 43430,0006000 | |
| 10,000 | 201.0 | 0.445 | 201.008 | 3,329,970 | 860,006 | |
| https://gerrit.onap.org/r/c/cps/+/133511/2** | 1,000 | 0.5 | 0.223 | 0.321 | 332,997 | 86,006 |
| 2,000 | 1.0 | 0.417 | 0.558 | 665,994 | 172,006 | |
| 5,000 | 2.5 | 1.087 | 1.439 | 1664985 | 430,006 | |
| 10,000 | 7.0 ??? Was this wrong ?! | 2.928 | 4.049 | 3329970 | 860,006 | |
| https://gerrit.onap.org/r/c/cps/+/133511/12 | 1,000 | 3.0 | 1.262 | 1.691 | 332997 | 86,006 |
| 2,000 | 5.5 | 2.317 | 3.173 | 665994 | 172,006 | |
| 5,000 | 11.0 | 5.433 | 5.591 | 1664985 | 430,006 | |
| 10,000 | 25.4 | 11.698 | 13.661 | 3329970 | 860,006 |
*Only initial Hibernate query
**
Graphs:
ttps://gerrit.onap.org/r/c/cps/+/133482:
...
https://gerrit.onap.org/r/c/cps/+/133511/12:
Conclusions:
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 ? | Total duration (s) | 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:
Conclusions:
Data sheets:
| View file | ||||
|---|---|---|---|---|
|
| View file | ||||
|---|---|---|---|---|
|