In Progress
Jira Legacy server System Jira serverId 01505d01-b853-3c2e-90f1-ee9b165564fc key PERF-100
Success criteria:
- Scripts to generate the data be checked in
- A report showing all the queries and times.
- Analysis of why a query with the * token is slow or fast, if possible.
Overview:
In PERF-83 it was observed that a CQL query with the * token at the end resulted in a faster response time, despite a much higher database usage.
There are many entities of different statuses in FOLIO. It'd be interesting to see if this pattern holds true for other statuses and CQL queries.
...
GET /circulation/loans?limit=2147483647&query=(itemId==${current_item} and status.name=="Closed*")
GET /circulation/requests?(itemId==${item_id} and (status=="Open - Awaiting pickup*" or status=="Open - Awaiting delivery*"))
GET /circulation/requests?(requesterId==${userID} and pickupServicePointId=${servicePoints_Id} and status=="Open - Awaiting pickup*")Version:
OKAPI - Version 3.1.1
...
| Test | Virtual Users | Query | Duration (sec) | Rump Up (sec) |
|---|---|---|---|---|
1 | 8 | /circulation/loans?limit=2147483647&query=(itemId==${current_item} and status.name=="Closed") | 1800 | 80 |
| 2 | 20 | /circulation/loans?limit=2147483647&query=(itemId==${current_item} and status.name=="Closed") | 200 | |
| 3 | 8 | /circulation/loans?limit=2147483647&query=(itemId==${current_item} and status.name=="Closed*") | 80 | |
| 4 | 20 | /circulation/loans?limit=2147483647&query=(itemId==${current_item} and status.name=="Closed*") | 200 | |
| 5 | 8 | /circulation/requests?(itemId==[current_item] and (status=="Open - Not yet filled" or status=="Open - Awaiting delivery")) | 80 | |
| 6 | 20 | /circulation/requests?(itemId==[current_item] and (status=="Open - Not yet filled" or status=="Open - Awaiting delivery")) | 200 | |
| 7 | 8 | /circulation/requests?(itemId==[item_id] and (status=="Open - Not yet filled*" or status=="Open - Awaiting delivery*")) | 80 | |
| 8 | 20 | /circulation/requests?(itemId==[item_id] and (status=="Open - Not yet filled*" or status=="Open - Awaiting delivery*")) | 200 | |
| 9 | 8 | /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled") | 80 | |
| 10 | 20 | /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled") | 200 | |
| 11 | 8 | /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled*") | 80 | |
| 12 | 20 | /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled*") | 200 |
...
| Test | Virtual Users | Requests | Total | OK | KO | % KO | Req/s | Min | 50th pct | 75th pct | 95th pct | 99th pct | Max | Average | Latency | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 8 | GET /circulation/loans?limit=2147483647&query=(itemId==[current_item] and status.name=="Closed") | link | 13788 | 13788 | 0 | 0 | 7.657 | 0.34 | 1.006 | 1.085 | 1.235 | 3.028 | 5.706 | 1.024 | 1.235 |
| 2 | 20 | GET /circulation/loans?limit=2147483647&query=(itemId==[current_item] and status.name=="Closed") | link | 12225 | 12143 | 82 | 0.671 | 6.786 | 0.352 | 2.441 | 3.815 | 4.736 | 6.181 | 30.171 | 2.79 | 4.736 |
| 3 | 8 | GET /circulation/loans?limit=2147483647&query=(itemId==[current_item] and status.name=="Closed*") | link | 13691 | 13582 | 109 | 0.796 | 7.596 | 0.331 | 0.996 | 1.074 | 1.226 | 3.205 | 32.6 | 1.032 | 1.226 |
| 4 | 20 | GET /circulation/loans?limit=2147483647&query=(itemId==[current_item] and status.name=="Closed*") | link | 12548 | 12548 | 0 | 0 | 6.966 | 0.322 | 2.438 | 3.799 | 4.715 | 5.46 | 9.462 | 2.718 | 4.715 |
| 5 | 8 | GET /circulation/requests?(itemId==[current_item] and (status==Open - Not yet filled or status==Open - Awaiting delivery)) | link | 69925 | 69925 | 0 | 0 | 39.479 | 0.114 | 0.187 | 0.204 | 0.24 | 0.309 | 4.328 | 0.198 | 0.24 |
| 6 | 20 | GET /circulation/requests?(itemId==[current_item] and (status==Open - Not yet filled or status==Open - Awaiting delivery)) | link | 86602 | 86602 | 0 | 0 | 48.106 | 0.115 | 0.379 | 0.423 | 0.513 | 0.661 | 15.306 | 0.393 | 0.513 |
| 7 | 8 | GET /circulation/requests?(itemId==[item_id] and (status=="Open - Awaiting pickup*" or status=="Open - Awaiting delivery*")) | link | 67688 | 67688 | 0 | 0 | 37.6 | 0.118 | 0.194 | 0.214 | 0.26 | 0.385 | 23.776 | 0.208 | 0.26 |
| 8 | 20 | GET /circulation/requests?(itemId==[item_id] and (status=="Open - Awaiting pickup*" or status=="Open - Awaiting delivery*")) | link | 78697 | 78697 | 0 | 0 | 43.714 | 0.114 | 0.411 | 0.48 | 0.607 | 0.969 | 8.646 | 0.433 | 0.607 |
| 9 | 8 | GET /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled") | link | 66713 | 66713 | 0 | 0 | 37.06 | 0.117 | 0.194 | 0.215 | 0.265 | 0.384 | 31.676 | 0.211 | 0.265 |
| 10 | 20 | GET /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled") | link | 79364 | 79364 | 0 | 0 | 44.086 | 0.115 | 0.41 | 0.477 | 0.603 | 0.99 | 3.834 | 0.429 | 0.603 |
| 11 | 8 | GET /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled*") | link | 66830 | 66830 | 0 | 0 | 37.125 | 0.116 | 0.196 | 0.217 | 0.269 | 0.401 | 2.991 | 0.211 | 0.269 |
| 12 | 20 | GET /circulation/requests?(requesterId==[requesterID] and pickupServicePointId=[pickPoint] and status=="Open - Not yet filled*") | link | 78824 | 78824 | 0 | 0 | 43.783 | 0.119 | 0.413 | 0.482 | 0.611 | 0.923 | 4.893 | 0.432 | 0.611 |
...