| Table of Contents |
|---|
...
- 7.2 million inventory records (7.3 Million instances, 7.8 Million holdings record, 8.9 Million items)
- 80 FOLIO back-end modules deployed in 166 ECS services
- 3 okapi ECS services
- 7 m5.xlarge EC2 instances
- 1 writer db.r6g.xlarge 1 reader db.r6g.xlarge AWS RDS instance
High-Level Summary
...
| Requests | Total | Req/s | Min | 50pct | 75pct | 95pct | 99pct | Max | Avg | Latency |
| fs09000000GET /search/authorities keyword <> random sentence | 233 | 0.065 | 0.250 | 0.264 | 0.298 | 0.520 | 0.721 | 0.973 | 0.302 | 0.520 |
| fs09000000GET /search/authorities keyword <> randomword | 233 | 0.065 | 0.246 | 0.261 | 0.289 | 0.548 | 0.810 | 1.771 | 0.312 | 0.548 |
| fs09000000GET /search/authorities keyword = *random sentence* | 233 | 0.065 | 0.567 | 0.710 | 0.962 | 1.681 | 2.240 | 2.582 | 0.874 | 1.681 |
| fs09000000GET /search/authorities keyword = random sentence | 233 | 0.065 | 0.017 | 0.021 | 0.023 | 0.034 | 0.048 | 0.074 | 0.023 | 0.034 |
| fs09000000GET /search/authorities keyword = randomword | 233 | 0.065 | 0.014 | 0.024 | 0.056 | 0.135 | 0.204 | 0.449 | 0.044 | 0.135 |
| fs09000000GET /search/authorities keyword == random sentence | 233 | 0.065 | 0.017 | 0.020 | 0.022 | 0.035 | 0.055 | 0.101 | 0.022 | 0.033 |
| fs09000000GET /search/authorities keyword == randomword | 233 | 0.065 | 0.015 | 0.022 | 0.034 | 0.089 | 0.164 | 0.241 | 0.034 | 0.089 |
| fs09000000GET /search/authorities keyword all *randomword* | 233 | 0.065 | 0.302 | 0.554 | 0.824 | 1.198 | 1.675 | 2.013 | 0.644 | 1.198 |
| fs09000000GET /search/authorities keyword all random sentence | 233 | 0.065 | 0.017 | 0.021 | 0.025 | 0.040 | 0.076 | 0.230 | 0.025 | 0.040 |
| fs09000000GET /search/authorities keyword all randomword | 233 | 0.065 | 0.025 | 0.047 | 0.089 | 0.158 | 0.270 | 0.379 | 0.067 | 0.158 |
| fs09000000GET /search/authorities keyword any random sentence | 233 | 0.065 | 0.017 | 0.092 | 0.129 | 0.200 | 0.315 | 0.354 | 0.098 | 0.199 |
| fs09000000GET /search/authorities keyword any randomword | 233 | 0.065 | 0.014 | 0.028 | 0.062 | 0.145 | 0.197 | 0.228 | 0.046 | 0.145 |
| fs09000000GET /search/instances: contributors <> 2random words | 233 | 0.065 | 0.255 | 0.274 | 0.296 | 0.422 | 0.752 | 1.599 | 0.302 | 0.420 |
| fs09000000GET /search/instances: contributors = *randomword | 233 | 0.065 | 0.449 | 0.481 | 0.570 | 0.943 | 1.357 | 1.790 | 0.562 | 0.942 |
| fs09000000GET /search/instances: contributors = randomword* | 233 | 0.065 | 0.013 | 0.041 | 0.160 | 0.219 | 0.242 | 0.276 | 0.084 | 0.218 |
| fs09000000GET /search/instances: contributors == 2random words | 233 | 0.065 | 0.013 | 0.020 | 0.026 | 0.040 | 0.069 | 0.078 | 0.023 | 0.039 |
| fs09000000GET /search/instances: contributors all 2random words | 233 | 0.065 | 0.014 | 0.017 | 0.024 | 0.038 | 0.136 | 0.211 | 0.023 | 0.038 |
| fs09000000GET /search/instances: contributors all randomword | 233 | 0.065 | 0.014 | 0.089 | 0.179 | 0.240 | 0.364 | 0.441 | 0.112 | 0.238 |
| fs09000000GET /search/instances: contributors any 2random words | 233 | 0.065 | 0.017 | 0.152 | 0.196 | 0.240 | 0.390 | 0.622 | 0.139 | 0.239 |
| fs09000000GET /search/instances: keyword <> 1word | 233 | 0.065 | 0.258 | 0.282 | 0.324 | 0.489 | 0.709 | 1.219 | 0.323 | 0.488 |
| fs09000000GET /search/instances: keyword <> random 2words | 233 | 0.065 | 0.259 | 0.281 | 0.330 | 0.570 | 0.725 | 0.803 | 0.326 | 0.569 |
| fs09000000GET /search/instances: keyword = 1word* | 233 | 0.065 | 0.018 | 0.170 | 0.207 | 0.274 | 0.456 | 0.591 | 0.159 | 0.273 |
| fs09000000GET /search/instances: keyword = random 2words | 233 | 0.065 | 0.016 | 0.051 | 0.082 | 0.153 | 0.299 | 0.313 | 0.063 | 0.153 |
| fs09000000GET /search/instances: keyword == random 2words | 233 | 0.065 | 0.016 | 0.028 | 0.041 | 0.082 | 0.122 | 0.370 | 0.037 | 0.082 |
| fs09000000GET /search/instances: keyword all random 2words | 233 | 0.065 | 0.018 | 0.059 | 0.096 | 0.198 | 0.397 | 0.434 | 0.080 | 0.197 |
| fs09000000GET /search/instances: keyword all random sentence AND languages == randomlang | 233 | 0.065 | 0.020 | 0.075 | 0.121 | 0.194 | 0.289 | 0.462 | 0.093 | 0.194 |
| fs09000000GET /search/instances: keyword any random 2words | 233 | 0.065 | 0.049 | 0.203 | 0.237 | 0.343 | 0.599 | 1.201 | 0.220 | 0.342 |
| fs09000000GET /search/instances: languages == (lang) AND items.status.name == ("Available" OR "In transit") | 233 | 0.065 | 0.043 | 0.057 | 0.172 | 0.237 | 0.377 | 0.453 | 0.105 | 0.236 |
| fs09000000GET /search/instances: languages == lang | 233 | 0.065 | 0.043 | 0.054 | 0.148 | 0.185 | 0.358 | 0.461 | 0.094 | 0.184 |
| fs09000000GET /search/instances: languages == lang AND items.status.name == "Available" | 233 | 0.065 | 0.047 | 0.070 | 0.213 | 0.244 | 0.494 | 0.618 | 0.127 | 0.243 |
| fs09000000GET /search/instances: subjects <> 1randomword | 233 | 0.065 | 0.015 | 0.183 | 0.219 | 0.259 | 0.357 | 0.697 | 0.169 | 0.258 |
| fs09000000GET /search/instances: subjects = (randomword OR randomword) | 233 | 0.065 | 0.023 | 0.173 | 0.216 | 0.258 | 0.407 | 0.453 | 0.167 | 0.257 |
| fs09000000GET /search/instances: subjects = *1randomword | 233 | 0.065 | 0.647 | 0.743 | 0.872 | 1.327 | 2.303 | 2.916 | 0.850 | 1.325 |
| fs09000000GET /search/instances: subjects = 1randomword* | 233 | 0.065 | 0.013 | 0.116 | 0.158 | 0.210 | 0.270 | 0.289 | 0.104 | 0.209 |
| fs09000000GET /search/instances: subjects == 1randomword | 233 | 0.065 | 0.014 | 0.054 | 0.109 | 0.201 | 0.245 | 0.390 | 0.081 | 0.199 |
| fs09000000GET /search/instances: subjects all 1randomword | 233 | 0.065 | 0.015 | 0.072 | 0.160 | 0.229 | 0.304 | 0.353 | 0.099 | 0.227 |
| fs09000000GET /search/instances: subjects all randomword AND title all randomword | 233 | 0.065 | 0.015 | 0.049 | 0.073 | 0.130 | 0.245 | 0.375 | 0.059 | 0.130 |
| fs09000000GET /search/instances: subjects all randomword NOT title all randomword | 233 | 0.065 | 0.015 | 0.187 | 0.236 | 0.334 | 0.514 | 0.745 | 0.182 | 0.333 |
| fs09000000GET /search/instances: subjects all randomword OR title all randomword | 233 | 0.065 | 0.026 | 0.213 | 0.256 | 0.325 | 0.461 | 0.528 | 0.214 | 0.324 |
| fs09000000GET /search/instances: subjects any 2random words | 233 | 0.065 | 0.016 | 0.132 | 0.176 | 0.245 | 0.459 | 0.802 | 0.141 | 0.243 |
| fs09000000GET /search/instances: title <> 3 word sentence | 232 | 0.065 | 0.260 | 0.282 | 0.314 | 0.499 | 0.692 | 0.751 | 0.320 | 0.498 |
| fs09000000GET /search/instances: title == 3 word sentence | 232 | 0.065 | 0.017 | 0.031 | 0.050 | 0.110 | 0.194 | 0.230 | 0.043 | 0.110 |
| fs09000000GET /search/instances: title all *1randomword | 232 | 0.065 | 4.602 | 5.811 | 8.438 | 11.234 | 14.750 | 15.833 | 6.886 | 11.234 |
| fs09000000GET /search/instances: title all 1randomword* | 232 | 0.065 | 0.017 | 0.085 | 0.174 | 0.236 | 0.380 | 0.622 | 0.117 | 0.234 |
| fs09000000GET /search/instances: title all 3 word sentence | 233 | 0.065 | 0.020 | 0.066 | 0.115 | 0.188 | 0.264 | 0.298 | 0.084 | 0.188 |
| fs09000000GET /search/instances: title any 3 word sentence | 233 | 0.065 | 0.116 | 0.313 | 0.690 | 1.747 | 2.429 | 2.833 | 0.585 | 1.745 |
| Wildcard queries | Avg (seconds) | Error |
| fs09000000GET /search/instances: contributors = randomword* | 0.084 | 0.0% |
| fs09000000GET /search/instances: keyword = 1word* | 0.159 | 0.0% |
| fs09000000GET /search/instances: subjects = 1randomword* | 0.104 | 0.0% |
| fs09000000GET /search/instances: title all 1randomword* | 0.117 | 0.0% |
| 0.2676 |
| Wildcard prefix queries | Avg (seconds) | Error |
| fs09000000GET /search/authorities keyword = *random sentence* | 0.874 | 0.0% |
| fs09000000GET /search/authorities keyword all *randomword* | 0.644 | 0.0% |
| fs09000000GET /search/instances: contributors = *randomword | 0.562 | 0.0% |
| fs09000000GET /search/authorities keyword all *randomword* | 0.644 | 0.0% |
| fs09000000GET /search/instances: subjects = *1randomword | 0.85 | 0.0% |
| fs09000000GET /search/instances: title all *1randomword | 6.886 | 0.0% |
| 1.74 |
Response time over time
Max response time was for query: fs09000000GET /search/instances: title all *1randomword - ~15 seconds For all other queries it was around 2.5 seconds or less.
...
Jira Legacy server System Jira serverId 01505d01-b853-3c2e-90f1-ee9b165564fc key MSEARCH-331 Jira Legacy server System Jira serverId 01505d01-b853-3c2e-90f1-ee9b165564fc key MSEARCH-337
...
- Different permutations of random words and sentences were generated from https://www.mit.edu/~ecprice/wordlist.10000
- Artifact stored http://carrier-io.int.folio.ebsco.com/artifacts?q=mod-search - mod-search.zip
...