Setup
Environment:
Linux Laptop, RAM, CPU
Data:
- # anchors ( nodes?)
- tree-size per anchor (# fragments) 86 ?
- KB per anchor 333KB ?
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']
(1 object out of many)
Patch | Nodes | Total duration (s) | Query duration (s) | Service duration (s) | Object Size (KB) | Object Size #Fragments |
---|---|---|---|---|---|---|
https://gerrit.onap.org/r/c/cps/+/133482 | 1000 | 0.045 | 0.023 | 0.022 | 332.997 | 86 |
2000 | 0.054 | 0.035 | 0.018 | |||
5000 | 0.144 | 0.117 | 0.027 | |||
10000 | 0.290 | 0.260 | 0.030 | |||
https://gerrit.onap.org/r/c/cps/+/133511/2 | 1000 | 0.054 | 0.053 | 0.001 | ||
2000 | 0.100 | 0.100 | 0.000 | |||
5000 | 0.229 | 0.229 | 0.000 | |||
10000 | 0.213 | 0.212 | 0.000 | |||
https://gerrit.onap.org/r/c/cps/+/133511/12 | 1000 | 0.020 | 0.016 | 0.004 | ||
2000 | 0.030 | 0.026 | 0.003 | |||
5000 | 0.113 | 0.108 | 0.005 | |||
10000 | 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:
Whole data tree as one request
1 object contaning all node as descendatnts
Patch | Nodes | Xpath | Total duration (s) | Query duration (s) | Service duration (s) | Object Size (KB) | Object Size #Fragments |
---|---|---|---|---|---|---|---|
https://gerrit.onap.org/r/c/cps/+/133482 | 1000 | cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-device | 11.772 | 0.031 | 11.740 | 332997 | 86006 |
2000 | 28.451 | 0.049 | 28.401 | 665994 | 172006 | ||
5000 | 86.973 | 0.158 | 86.814 | 1664985 | 430006 | ||
10000 | 201.453 | 0.445 | 201.008 | 3329970 | 860006 | ||
https://gerrit.onap.org/r/c/cps/+/133511/2 | 1000 | 0.545 | 0.223 | 0.321 | 332997 | 86006 | |
2000 | 0.976 | 0.417 | 0.558 | 665994 | 172006 | ||
5000 | 2.527 | 1.087 | 1.439 | 1664985 | 430006 | ||
10000 | 6.977 | 2.928 | 4.049 | 3329970 | 860006 | ||
https://gerrit.onap.org/r/c/cps/+/133511/12 | 1000 | 2.954 | 1.262 | 1.691 | 332997 | 86006 | |
2000 | 5.491 | 2.317 | 3.173 | 665994 | 172006 | ||
5000 | 11.024 | 5.433 | 5.591 | 1664985 | 430006 | ||
10000 | 25.359 | 11.698 | 13.661 | 3329970 | 860006 |
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:
Get nodes parallel
Patch | Nodes | Xpath | Total duration (s) | Query duration (s) | Object Size (KB) | Object Size #Fragments |
---|---|---|---|---|---|---|
https://gerrit.onap.org/r/c/cps/+/133511/12 | 1 | cps/api/v1/dataspaces/openroadm/anchors/owb-msa221-anchor/node?xpath=/openroadm-devices/openroadm-device[@device-id='C201-7-13A-5A1'] | 0.082 | 0.238 | 332.997 | 86 |
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: