| 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 | 1508 | 0.420 | 0.149 | 0.723 | 1.042 | 1.781 | 2.589 | 6.343 | 0.850 | 1.781 |
| fs09000000GET /search/authorities keyword <> randomword | 1511 | 0.420 | 0.156 | 0.713 | 1.030 | 1.840 | 2.887 | 5.796 | 0.851 | 1.836 |
| fs09000000GET /search/authorities keyword = *random sentence* | 1508 | 0.420 | 0.883 | 1.671 | 2.048 | 2.847 | 4.687 | 8.326 | 1.788 | 2.847 |
| fs09000000GET /search/authorities keyword = random sentence | 1508 | 0.420 | 0.031 | 0.460 | 0.717 | 1.376 | 2.219 | 10.218 | 0.596 | 1.376 |
| fs09000000GET /search/authorities keyword = randomword | 1511 | 0.420 | 0.026 | 0.449 | 0.711 | 1.406 | 2.594 | 6.043 | 0.593 | 1.404 |
| fs09000000GET /search/authorities keyword == random sentence | 1508 | 0.420 | 0.068 | 0.447 | 0.693 | 1.278 | 2.153 | 5.411 | 0.558 | 1.278 |
| fs09000000GET /search/authorities keyword == randomword | 1510 | 0.420 | 0.016 | 0.472 | 0.734 | 1.561 | 2.577 | 7.378 | 0.614 | 1.561 |
| fs09000000GET /search/authorities keyword all *randomword* | 1510 | 0.419 | 0.545 | 1.359 | 1.743 | 2.545 | 3.722 | 6.997 | 1.468 | 2.545 |
| fs09000000GET /search/authorities keyword all random sentence | 1509 | 0.419 | 0.053 | 0.471 | 0.722 | 1.361 | 2.491 | 5.385 | 0.591 | 1.361 |
| fs09000000GET /search/authorities keyword all randomword | 1512 | 0.420 | 0.021 | 0.486 | 0.771 | 1.603 | 2.648 | 5.197 | 0.632 | 1.603 |
| fs09000000GET /search/authorities keyword any random sentence | 1508 | 0.420 | 0.051 | 0.507 | 0.767 | 1.464 | 2.614 | 5.463 | 0.636 | 1.464 |
| fs09000000GET /search/authorities keyword any randomword | 1512 | 0.420 | 0.019 | 0.485 | 0.759 | 1.546 | 2.559 | 4.932 | 0.613 | 1.546 |
| fs09000000GET /search/instances: contributors <> 2random words | 1506 | 0.420 | 0.229 | 0.845 | 1.202 | 2.095 | 3.866 | 10.696 | 0.998 | 2.094 |
| fs09000000GET /search/instances: contributors = *randomword | 1506 | 0.420 | 0.602 | 1.360 | 1.728 | 2.526 | 3.411 | 4.899 | 1.472 | 2.526 |
| fs09000000GET /search/instances: contributors = randomword* | 1506 | 0.420 | 0.064 | 0.508 | 0.778 | 1.548 | 2.319 | 6.598 | 0.642 | 1.547 |
| fs09000000GET /search/instances: contributors == 2random words | 1506 | 0.420 | 0.065 | 0.459 | 0.702 | 1.401 | 2.373 | 6.619 | 0.588 | 1.401 |
| fs09000000GET /search/instances: contributors all 2random words | 1506 | 0.420 | 0.058 | 0.472 | 0.749 | 1.424 | 2.618 | 5.975 | 0.607 | 1.424 |
| fs09000000GET /search/instances: contributors all randomword | 1508 | 0.420 | 0.042 | 0.550 | 0.813 | 1.512 | 2.460 | 6.007 | 0.670 | 1.512 |
| fs09000000GET /search/instances: contributors any 2random words | 1506 | 0.420 | 0.090 | 0.590 | 0.860 | 1.558 | 2.395 | 11.632 | 0.726 | 1.556 |
| fs09000000GET /search/instances: keyword <> 1word | 1503 | 0.419 | 0.219 | 0.890 | 1.219 | 2.047 | 2.918 | 10.988 | 1.012 | 2.046 |
| fs09000000GET /search/instances: keyword <> random 2words | 1504 | 0.419 | 0.215 | 0.852 | 1.190 | 1.924 | 2.871 | 6.320 | 0.975 | 1.922 |
| fs09000000GET /search/instances: keyword = 1word* | 1503 | 0.419 | 0.065 | 0.598 | 0.867 | 1.558 | 2.587 | 4.883 | 0.728 | 1.557 |
| fs09000000GET /search/instances: keyword = random 2words | 1504 | 0.419 | 0.077 | 0.472 | 0.714 | 1.436 | 2.553 | 4.621 | 0.601 | 1.434 |
| fs09000000GET /search/instances: keyword == random 2words | 1504 | 0.419 | 0.079 | 0.489 | 0.771 | 1.417 | 2.254 | 6.359 | 0.614 | 1.417 |
| fs09000000GET /search/instances: keyword all random 2words | 1505 | 0.419 | 0.057 | 0.526 | 0.770 | 1.453 | 2.730 | 9.947 | 0.649 | 1.453 |
| fs09000000GET /search/instances: keyword all random sentence AND languages == randomlang | 1506 | 0.420 | 0.066 | 0.492 | 0.740 | 1.497 | 2.171 | 4.692 | 0.619 | 1.484 |
| fs09000000GET /search/instances: keyword any random 2words | 1504 | 0.419 | 0.188 | 0.661 | 0.941 | 1.595 | 2.520 | 7.017 | 0.790 | 1.594 |
| fs09000000GET /search/instances: languages == (lang) AND items.status.name == ("Available" OR "In transit") | 1505 | 0.419 | 0.103 | 0.612 | 0.903 | 1.685 | 2.572 | 8.275 | 0.746 | 1.681 |
| fs09000000GET /search/instances: languages == lang | 1505 | 0.419 | 0.106 | 0.584 | 0.876 | 1.530 | 2.430 | 7.004 | 0.712 | 1.528 |
| fs09000000GET /search/instances: languages == lang AND items.status.name == "Available" | 1506 | 0.419 | 0.099 | 0.638 | 0.929 | 1.727 | 2.791 | 7.607 | 0.778 | 1.720 |
| fs09000000GET /search/instances: subjects <> 1randomword | 1498 | 0.418 | 0.082 | 0.589 | 0.867 | 1.665 | 3.147 | 14.882 | 0.744 | 1.664 |
| fs09000000GET /search/instances: subjects = (randomword OR randomword) | 1508 | 0.420 | 0.107 | 0.591 | 0.861 | 1.535 | 2.498 | 5.127 | 0.719 | 1.534 |
| fs09000000GET /search/instances: subjects = *1randomword | 1500 | 0.418 | 0.827 | 1.796 | 2.211 | 3.160 | 4.472 | 7.100 | 1.915 | 3.160 |
| fs09000000GET /search/instances: subjects = 1randomword* | 1502 | 0.419 | 0.052 | 0.544 | 0.804 | 1.495 | 2.269 | 7.514 | 0.660 | 1.495 |
| fs09000000GET /search/instances: subjects == 1randomword | 1499 | 0.418 | 0.057 | 0.554 | 0.840 | 1.696 | 2.676 | 4.595 | 0.694 | 1.695 |
| fs09000000GET /search/instances: subjects all 1randomword | 1502 | 0.419 | 0.070 | 0.547 | 0.800 | 1.416 | 2.367 | 4.632 | 0.658 | 1.415 |
| fs09000000GET /search/instances: subjects all randomword AND title all randomword | 1508 | 0.420 | 0.068 | 0.489 | 0.767 | 1.456 | 2.203 | 11.435 | 0.619 | 1.456 |
| fs09000000GET /search/instances: subjects all randomword NOT title all randomword | 1508 | 0.420 | 0.096 | 0.619 | 0.916 | 1.653 | 2.430 | 6.527 | 0.748 | 1.649 |
| fs09000000GET /search/instances: subjects all randomword OR title all randomword | 1508 | 0.420 | 0.152 | 0.622 | 0.896 | 1.652 | 2.654 | 7.750 | 0.758 | 1.650 |
| fs09000000GET /search/instances: subjects any 2random words | 1499 | 0.418 | 0.088 | 0.582 | 0.873 | 1.559 | 2.656 | 8.047 | 0.724 | 1.557 |
| fs09000000GET /search/instances: title <> 3 word sentence | 1497 | 0.418 | 0.266 | 0.888 | 1.229 | 2.040 | 4.183 | 7.922 | 1.028 | 2.038 |
| fs09000000GET /search/instances: title == 3 word sentence | 1497 | 0.418 | 0.079 | 0.499 | 0.782 | 1.551 | 2.437 | 8.389 | 0.640 | 1.551 |
| fs09000000GET /search/instances: title all *1randomword | 1497 | 0.417 | 5.253 | 10.627 | 13.455 | 19.914 | 22.201 | 28.924 | 11.478 | 19.914 |
| fs09000000GET /search/instances: title all 1randomword* | 1497 | 0.418 | 0.064 | 0.599 | 0.907 | 1.706 | 3.154 | 7.831 | 0.764 | 1.704 |
| fs09000000GET /search/instances: title all 3 word sentence | 1498 | 0.418 | 0.072 | 0.482 | 0.756 | 1.504 | 2.588 | 6.353 | 0.630 | 1.504 |
| fs09000000GET /search/instances: title any 3 word sentence | 1498 | 0.418 | 0.270 | 1.008 | 1.705 | 3.755 | 5.009 | 14.345 | 1.396 | 3.754 |
| Wildcard queries | Avg (seconds) | Error |
| fs09000000GET /search/instances: contributors = randomword* | 0.642 | 0.0% |
| fs09000000GET /search/instances: keyword = 1word* | 0.728 | 0.0% |
| fs09000000GET /search/instances: subjects = 1randomword* | 0.660 | 0.0% |
| fs09000000GET /search/instances: title all 1randomword* | 0.764 | 0.0% |
| 0.698 |
| Wildcard prefix queries | Avg (seconds) | Error |
| fs09000000GET /search/authorities keyword = *random sentence* | 1.788 | 0.0% |
| fs09000000GET /search/authorities keyword all *randomword* | 1.468 | 0.0% |
| fs09000000GET /search/instances: contributors = *randomword | 1.472 | 0.0% |
| fs09000000GET /search/instances: subjects = *1randomword | 1.915 | 0.0% |
| fs09000000GET /search/instances: title all *1randomword | 11.478 | 0.0% |
| 3.624 |
Response time over time
Max response time was for query: fs09000000GET /search/instances: title all *1randomword - ~28 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
...