| 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 | 175 | 0.049 | 0.088 | 0.221 | 0.339 | 0.557 | 0.685 | 1.104 | 0.263 | 0.557 |
| fs09000000GET /search/authorities keyword <> randomword | 175 | 0.049 | 0.087 | 0.158 | 0.289 | 0.505 | 0.592 | 1.069 | 0.216 | 0.505 |
| fs09000000GET /search/authorities keyword = *random sentence* | 175 | 0.049 | 0.570 | 0.917 | 1.203 | 1.708 | 2.337 | 3.768 | 1.013 | 1.708 |
| fs09000000GET /search/authorities keyword = random sentence | 175 | 0.049 | 0.017 | 0.021 | 0.028 | 0.046 | 0.067 | 0.106 | 0.026 | 0.046 |
| fs09000000GET /search/authorities keyword = randomword | 175 | 0.049 | 0.015 | 0.028 | 0.054 | 0.140 | 0.186 | 0.342 | 0.046 | 0.140 |
| fs09000000GET /search/authorities keyword == random sentence | 175 | 0.049 | 0.017 | 0.021 | 0.029 | 0.068 | 0.167 | 0.210 | 0.029 | 0.068 |
| fs09000000GET /search/authorities keyword == randomword | 175 | 0.049 | 0.015 | 0.026 | 0.040 | 0.150 | 0.229 | 0.271 | 0.042 | 0.149 |
| fs09000000GET /search/authorities keyword all *randomword* | 175 | 0.049 | 0.311 | 0.657 | 0.839 | 1.269 | 1.490 | 3.562 | 0.720 | 1.269 |
| fs09000000GET /search/authorities keyword all random sentence | 175 | 0.049 | 0.017 | 0.026 | 0.035 | 0.073 | 0.137 | 0.198 | 0.033 | 0.073 |
| fs09000000GET /search/authorities keyword all randomword | 175 | 0.049 | 0.025 | 0.047 | 0.120 | 0.195 | 0.279 | 0.652 | 0.083 | 0.195 |
| fs09000000GET /search/authorities keyword any random sentence | 175 | 0.049 | 0.018 | 0.145 | 0.190 | 0.342 | 0.408 | 0.425 | 0.149 | 0.342 |
| fs09000000GET /search/authorities keyword any randomword | 175 | 0.049 | 0.014 | 0.030 | 0.090 | 0.208 | 0.244 | 0.387 | 0.062 | 0.208 |
| fs09000000GET /search/instances: contributors <> 2random words | 175 | 0.049 | 0.144 | 0.313 | 0.387 | 0.668 | 0.773 | 0.969 | 0.339 | 0.667 |
| fs09000000GET /search/instances: contributors = *randomword | 175 | 0.049 | 0.460 | 0.739 | 0.940 | 1.445 | 2.064 | 2.245 | 0.830 | 1.444 |
| fs09000000GET /search/instances: contributors = randomword* | 175 | 0.049 | 0.014 | 0.077 | 0.213 | 0.313 | 0.374 | 0.407 | 0.119 | 0.312 |
| fs09000000GET /search/instances: contributors == 2random words | 175 | 0.049 | 0.014 | 0.027 | 0.036 | 0.061 | 0.109 | 0.208 | 0.032 | 0.061 |
| fs09000000GET /search/instances: contributors all 2random words | 175 | 0.049 | 0.014 | 0.020 | 0.028 | 0.048 | 0.058 | 0.072 | 0.025 | 0.048 |
| fs09000000GET /search/instances: contributors all randomword | 175 | 0.049 | 0.015 | 0.143 | 0.257 | 0.325 | 0.421 | 0.607 | 0.159 | 0.325 |
| fs09000000GET /search/instances: contributors any 2random words | 175 | 0.049 | 0.019 | 0.205 | 0.272 | 0.381 | 0.437 | 0.593 | 0.198 | 0.379 |
| fs09000000GET /search/instances: keyword <> 1word | 175 | 0.049 | 0.144 | 0.324 | 0.429 | 0.653 | 0.769 | 1.073 | 0.352 | 0.652 |
| fs09000000GET /search/instances: keyword <> random 2words | 175 | 0.049 | 0.149 | 0.316 | 0.418 | 0.690 | 1.037 | 1.177 | 0.365 | 0.688 |
| fs09000000GET /search/instances: keyword = 1word* | 175 | 0.049 | 0.018 | 0.228 | 0.267 | 0.377 | 0.587 | 0.799 | 0.217 | 0.376 |
| fs09000000GET /search/instances: keyword = random 2words | 175 | 0.049 | 0.017 | 0.072 | 0.123 | 0.198 | 0.271 | 0.421 | 0.087 | 0.198 |
| fs09000000GET /search/instances: keyword == random 2words | 175 | 0.049 | 0.017 | 0.032 | 0.074 | 0.178 | 0.303 | 0.345 | 0.060 | 0.178 |
| fs09000000GET /search/instances: keyword all random 2words | 175 | 0.049 | 0.019 | 0.106 | 0.156 | 0.271 | 0.360 | 0.435 | 0.125 | 0.271 |
| fs09000000GET /search/instances: keyword all random sentence AND languages == randomlang | 175 | 0.049 | 0.048 | 0.169 | 0.226 | 0.306 | 0.492 | 0.807 | 0.181 | 0.306 |
| fs09000000GET /search/instances: keyword any random 2words | 175 | 0.049 | 0.054 | 0.282 | 0.372 | 0.560 | 0.796 | 1.031 | 0.324 | 0.559 |
| fs09000000GET /search/instances: languages == (lang) AND items.status.name == ("Available" OR "In transit") | 175 | 0.049 | 0.045 | 0.081 | 0.183 | 0.284 | 0.408 | 0.441 | 0.125 | 0.283 |
| fs09000000GET /search/instances: languages == lang | 175 | 0.049 | 0.044 | 0.081 | 0.164 | 0.299 | 0.379 | 0.519 | 0.120 | 0.298 |
| fs09000000GET /search/instances: languages == lang AND items.status.name == "Available" | 175 | 0.049 | 0.049 | 0.108 | 0.234 | 0.423 | 0.615 | 0.676 | 0.167 | 0.422 |
| fs09000000GET /search/instances: subjects <> 1randomword | 175 | 0.049 | 0.016 | 0.249 | 0.281 | 0.380 | 0.448 | 0.555 | 0.228 | 0.379 |
| fs09000000GET /search/instances: subjects = (randomword OR randomword) | 175 | 0.049 | 0.024 | 0.248 | 0.287 | 0.363 | 0.464 | 0.682 | 0.242 | 0.362 |
| fs09000000GET /search/instances: subjects = *1randomword | 175 | 0.049 | 0.693 | 1.071 | 1.305 | 1.849 | 2.368 | 2.855 | 1.156 | 1.848 |
| fs09000000GET /search/instances: subjects = 1randomword* | 175 | 0.049 | 0.014 | 0.169 | 0.218 | 0.283 | 0.308 | 0.576 | 0.144 | 0.281 |
| fs09000000GET /search/instances: subjects == 1randomword | 175 | 0.049 | 0.015 | 0.076 | 0.159 | 0.288 | 0.366 | 0.565 | 0.111 | 0.287 |
| fs09000000GET /search/instances: subjects all 1randomword | 175 | 0.049 | 0.014 | 0.112 | 0.212 | 0.297 | 0.397 | 1.243 | 0.142 | 0.296 |
| fs09000000GET /search/instances: subjects all randomword AND title all randomword | 175 | 0.049 | 0.023 | 0.088 | 0.122 | 0.200 | 0.297 | 0.511 | 0.100 | 0.200 |
| fs09000000GET /search/instances: subjects all randomword NOT title all randomword | 175 | 0.049 | 0.023 | 0.279 | 0.341 | 0.445 | 0.557 | 0.709 | 0.265 | 0.444 |
| fs09000000GET /search/instances: subjects all randomword OR title all randomword | 175 | 0.049 | 0.068 | 0.310 | 0.358 | 0.521 | 0.728 | 0.836 | 0.326 | 0.520 |
| fs09000000GET /search/instances: subjects any 2random words | 175 | 0.049 | 0.020 | 0.206 | 0.262 | 0.345 | 0.495 | 0.597 | 0.201 | 0.344 |
| fs09000000GET /search/instances: title <> 3 word sentence | 175 | 0.049 | 0.152 | 0.347 | 0.458 | 0.771 | 1.131 | 1.180 | 0.397 | 0.770 |
| fs09000000GET /search/instances: title == 3 word sentence | 175 | 0.049 | 0.017 | 0.037 | 0.120 | 0.204 | 0.359 | 0.413 | 0.079 | 0.204 |
| fs09000000GET /search/instances: title all *1randomword | 175 | 0.049 | 5.006 | 8.103 | 11.273 | 18.093 | 22.114 | 22.748 | 9.568 | 18.093 |
| fs09000000GET /search/instances: title all 1randomword* | 175 | 0.049 | 0.017 | 0.113 | 0.245 | 0.391 | 0.504 | 0.639 | 0.159 | 0.390 |
| fs09000000GET /search/instances: title all 3 word sentence | 175 | 0.049 | 0.039 | 0.133 | 0.178 | 0.274 | 0.317 | 0.777 | 0.148 | 0.274 |
| fs09000000GET /search/instances: title any 3 word sentence | 175 | 0.049 | 0.175 | 0.473 | 0.995 | 2.822 | 3.720 | 4.922 | 0.860 | 2.821 |
| fs09000000GET /search/instances: keyword = 1word* | 175 | 0.049 | 0.018 | 0.228 | 0.267 | 0.377 | 0.587 | 0.799 | 0.217 | 0.376 |
| Wildcard queries | Avg (seconds) | Error |
| fs09000000GET /search/instances: contributors = randomword* | 0.119 | |
| fs09000000GET /search/instances: keyword = 1word* | 0.217 | |
| fs09000000GET /search/instances: subjects = 1randomword* | 0.144 | |
| fs09000000GET /search/instances: title all 1randomword* | 0.159 | |
| 0.159 |
| Wildcard prefix queries | Avg (seconds) | Error |
| fs09000000GET /search/authorities keyword = *random sentence* | 1.013 | 0.0% |
| fs09000000GET /search/authorities keyword all *randomword* | 0.720 | 0.0% |
| fs09000000GET /search/instances: contributors = *randomword | 0.830 | 0.0% |
| fs09000000GET /search/instances: subjects = *1randomword | 1.156 | 0.0% |
| fs09000000GET /search/instances: title all *1randomword | 9.568 | 0.0% |
| 2.657 |
Response Time Over Time
Max response time was for query: fs09000000GET /search/instances: title all *1randomword spiked to ~22 seconds For all other queries it was closer to 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
...