| Table of Contents |
|---|
Overview
...
- 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 | 1297 | 0.361 | 0.202 | 0.823 | 1.113 | 1.955 | 2.636 | 3.544 | 0.936 | 1.955 |
| fs09000000GET /search/authorities keyword <> randomword | 1299 | 0.361 | 0.110 | 0.794 | 1.136 | 2.123 | 3.487 | 9.501 | 0.968 | 2.123 |
| fs09000000GET /search/authorities keyword = *random sentence* | 1295 | 0.360 | 0.935 | 1.935 | 2.400 | 3.303 | 4.113 | 11.918 | 2.045 | 3.303 |
| fs09000000GET /search/authorities keyword = random sentence | 1295 | 0.360 | 0.102 | 0.551 | 0.815 | 1.523 | 2.523 | 10.937 | 0.680 | 1.523 |
| fs09000000GET /search/authorities keyword = randomword | 1300 | 0.361 | 0.016 | 0.551 | 0.827 | 1.679 | 2.680 | 12.588 | 0.707 | 1.679 |
| fs09000000GET /search/authorities keyword == random sentence | 1297 | 0.361 | 0.094 | 0.565 | 0.869 | 1.626 | 2.534 | 8.289 | 0.711 | 1.626 |
| fs09000000GET /search/authorities keyword == randomword | 1298 | 0.361 | 0.021 | 0.556 | 0.839 | 1.608 | 2.582 | 8.349 | 0.701 | 1.608 |
| fs09000000GET /search/authorities keyword all *randomword* | 1298 | 0.361 | 0.564 | 1.520 | 1.997 | 3.083 | 4.290 | 10.092 | 1.691 | 3.083 |
| fs09000000GET /search/authorities keyword all random sentence | 1297 | 0.361 | 0.105 | 0.549 | 0.829 | 1.657 | 2.655 | 8.973 | 0.688 | 1.657 |
| fs09000000GET /search/authorities keyword all randomword | 1300 | 0.361 | 0.017 | 0.564 | 0.830 | 1.617 | 2.824 | 9.527 | 0.714 | 1.617 |
| fs09000000GET /search/authorities keyword any random sentence | 1297 | 0.361 | 0.147 | 0.604 | 0.868 | 1.763 | 2.818 | 9.430 | 0.751 | 1.763 |
| fs09000000GET /search/authorities keyword any randomword | 1300 | 0.361 | 0.018 | 0.567 | 0.848 | 1.645 | 3.012 | 8.022 | 0.721 | 1.645 |
| fs09000000GET /search/instances: contributors <> 2random words | 1292 | 0.361 | 0.246 | 0.935 | 1.273 | 2.185 | 3.219 | 7.719 | 1.072 | 2.184 |
| fs09000000GET /search/instances: contributors = *randomword | 1293 | 0.360 | 0.672 | 1.611 | 2.000 | 2.919 | 4.005 | 13.528 | 1.764 | 2.919 |
| fs09000000GET /search/instances: contributors = randomword* | 1293 | 0.360 | 0.094 | 0.615 | 0.948 | 1.813 | 3.178 | 8.855 | 0.791 | 1.813 |
| fs09000000GET /search/instances: contributors == 2random words | 1292 | 0.361 | 0.118 | 0.542 | 0.809 | 1.567 | 2.535 | 9.101 | 0.675 | 1.567 |
| fs09000000GET /search/instances: contributors all 2random words | 1292 | 0.361 | 0.092 | 0.566 | 0.813 | 1.600 | 2.309 | 13.326 | 0.685 | 1.600 |
| fs09000000GET /search/instances: contributors all randomword | 1293 | 0.360 | 0.139 | 0.665 | 0.984 | 1.889 | 2.997 | 11.820 | 0.829 | 1.887 |
| fs09000000GET /search/instances: contributors any 2random words | 1292 | 0.361 | 0.152 | 0.692 | 0.977 | 1.842 | 3.031 | 8.169 | 0.844 | 1.841 |
| fs09000000GET /search/instances: keyword <> 1word | 1286 | 0.359 | 0.280 | 0.969 | 1.312 | 2.150 | 3.066 | 5.673 | 1.100 | 2.149 |
| fs09000000GET /search/instances: keyword <> random 2words | 1287 | 0.360 | 0.303 | 0.961 | 1.303 | 2.139 | 3.006 | 12.240 | 1.106 | 2.138 |
| fs09000000GET /search/instances: keyword = 1word* | 1287 | 0.360 | 0.168 | 0.738 | 1.034 | 1.908 | 2.872 | 9.941 | 0.885 | 1.907 |
| fs09000000GET /search/instances: keyword = random 2words | 1289 | 0.360 | 0.115 | 0.572 | 0.884 | 1.639 | 2.549 | 5.710 | 0.714 | 1.639 |
| fs09000000GET /search/instances: keyword == random 2words | 1287 | 0.360 | 0.131 | 0.570 | 0.870 | 1.759 | 2.572 | 8.373 | 0.725 | 1.759 |
| fs09000000GET /search/instances: keyword all random 2words | 1290 | 0.360 | 0.117 | 0.606 | 0.916 | 1.732 | 2.678 | 11.065 | 0.772 | 1.731 |
| fs09000000GET /search/instances: keyword all random sentence AND languages == randomlang | 1292 | 0.361 | 0.108 | 0.592 | 0.875 | 1.633 | 2.548 | 8.574 | 0.733 | 1.633 |
| fs09000000GET /search/instances: keyword any random 2words | 1289 | 0.360 | 0.269 | 0.775 | 1.113 | 1.960 | 2.838 | 8.873 | 0.931 | 1.959 |
| fs09000000GET /search/instances: languages == (lang) AND items.status.name == ("Available" OR "In transit") | 1292 | 0.361 | 0.188 | 0.741 | 1.035 | 1.821 | 2.858 | 11.866 | 0.868 | 1.819 |
| fs09000000GET /search/instances: languages == lang | 1292 | 0.361 | 0.175 | 0.686 | 0.983 | 1.827 | 2.765 | 5.447 | 0.823 | 1.826 |
| fs09000000GET /search/instances: languages == lang AND items.status.name == "Available" | 1292 | 0.361 | 0.164 | 0.778 | 1.089 | 1.927 | 3.108 | 12.475 | 0.922 | 1.926 |
| fs09000000GET /search/instances: subjects <> 1randomword | 1285 | 0.360 | 0.148 | 0.697 | 0.984 | 1.728 | 2.618 | 9.452 | 0.839 | 1.727 |
| fs09000000GET /search/instances: subjects = (randomword OR randomword) | 1294 | 0.360 | 0.200 | 0.735 | 1.032 | 1.852 | 3.152 | 11.812 | 0.892 | 1.847 |
| fs09000000GET /search/instances: subjects = *1randomword | 1285 | 0.360 | 0.923 | 2.121 | 2.557 | 3.713 | 5.281 | 8.462 | 2.252 | 3.712 |
| fs09000000GET /search/instances: subjects = 1randomword* | 1285 | 0.360 | 0.130 | 0.641 | 0.945 | 1.668 | 2.945 | 9.114 | 0.787 | 1.667 |
| fs09000000GET /search/instances: subjects == 1randomword | 1285 | 0.360 | 0.107 | 0.612 | 0.918 | 1.725 | 2.919 | 11.933 | 0.775 | 1.724 |
| fs09000000GET /search/instances: subjects all 1randomword | 1286 | 0.359 | 0.152 | 0.668 | 0.984 | 1.815 | 2.787 | 12.340 | 0.815 | 1.813 |
| fs09000000GET /search/instances: subjects all randomword AND title all randomword | 1294 | 0.360 | 0.118 | 0.605 | 0.873 | 1.727 | 2.714 | 6.724 | 0.739 | 1.727 |
| fs09000000GET /search/instances: subjects all randomword NOT title all randomword | 1294 | 0.360 | 0.123 | 0.738 | 1.064 | 1.852 | 2.876 | 5.605 | 0.882 | 1.851 |
| fs09000000GET /search/instances: subjects all randomword OR title all randomword | 1294 | 0.360 | 0.206 | 0.747 | 1.051 | 1.986 | 3.539 | 11.722 | 0.924 | 1.985 |
| fs09000000GET /search/instances: subjects any 2random words | 1285 | 0.360 | 0.131 | 0.691 | 0.967 | 1.839 | 2.728 | 9.587 | 0.839 | 1.837 |
| fs09000000GET /search/instances: title <> 3 word sentence | 1285 | 0.360 | 0.266 | 0.959 | 1.313 | 2.103 | 3.439 | 16.493 | 1.132 | 2.102 |
| fs09000000GET /search/instances: title == 3 word sentence | 1285 | 0.360 | 0.078 | 0.593 | 0.890 | 1.796 | 4.453 | 16.146 | 0.820 | 1.796 |
| fs09000000GET /search/instances: title all *1randomword | 1284 | 0.359 | 5.481 | 12.403 | 15.789 | 22.022 | 25.269 | 33.003 | 13.309 | 22.022 |
| fs09000000GET /search/instances: title all 1randomword* | 1284 | 0.360 | 0.120 | 0.682 | 0.981 | 1.988 | 3.632 | 12.476 | 0.865 | 1.987 |
| fs09000000GET /search/instances: title all 3 word sentence | 1285 | 0.360 | 0.097 | 0.590 | 0.864 | 1.766 | 3.475 | 12.152 | 0.779 | 1.766 |
| fs09000000GET /search/instances: title any 3 word sentence | 1285 | 0.360 | 0.326 | 1.109 | 1.942 | 4.373 | 6.041 | 12.549 | 1.612 | 4.371 |
| Wildcard queries | Avg (seconds) | Error |
| fs09000000GET /search/instances: contributors = randomword* | 0.791 | 0.0% |
| fs09000000GET /search/instances: keyword = 1word* | 0.885 | 0.0% |
| fs09000000GET /search/instances: subjects = 1randomword* | 0.787 | 0.0% |
| fs09000000GET /search/instances: title all 1randomword* | 0.865 | 0.0% |
| 0.832 |
| Wildcard prefix queries | Avg (seconds) | Error |
| fs09000000GET /search/authorities keyword = *random sentence* | 2.045 | 0.0% |
| fs09000000GET /search/authorities keyword all *randomword* | 1.691 | 0.0% |
| fs09000000GET /search/instances: contributors = *randomword | 1.764 | 0.0% |
| fs09000000GET /search/instances: subjects = *1randomword | 2.252 | 0.0% |
| fs09000000GET /search/instances: title all *1randomword | 13.309 | 0.0% |
| 4.212 |
Response time over time
Max response time was for query: fs09000000GET /search/instances: title all *1randomword - ~30 seconds For all other queries it is closer to 10 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
...