Approach
Current query to retrieve the subject counts provides results in 4-6 second. It can be optimized using following approaches:
...
Property | Value |
|---|
| Environment | https://falcon-perf-okapi.ci.folio.org |
| mod-search | 3 nodes with CPU limit = 1024m and memoryLimit = 1200MB |
| okapi | 3 nodes with CPU limit = 256m and memoryLimit = 536MB |
| mod-authtoken | 2 nodes with CPU limit = 128m and memoryLimit = 360MB |
| mod-login | 2 nodes with CPU limit = 128m and memoryLimit = 536MB |
| mod-permissions | 2 nodes with CPU limit = 128m and memoryLimit = 536MB |
| ElasticSearch | AWS based Number of nodes: 4 Resources: r6g.large, 16 GiB of Memory, 2 vCPUs, EBS only, 64-bit Arm platform Properties: timeout=30 |
| Search queries | Terms| Code Block |
|---|
| linenumbers | true |
|---|
| collapse | true |
|---|
| washington
africa
independence
media
disk
comparison
computer
series
system
housing
trainer
airport
priority
emotion
possession
topic
appointment
mixture
committee
awareness
way
hospital
success
addition
hearing
worker
combination
effort
fortune
interaction
hospital
lady
confusion
music
throat
agency
science
wedding
exam
honey
pizza
leadership
marketing
road
initiative
audience
poem
fortune
elevator
area
dirt
height
breath
charity
two
success
engine
length
quantity
suggestion
supermarket
reputation
shopping
administration
outcome
promotion
mode
profession
shirt
funeral
hair
cheek
patience
independence
psychology
effort
engineering
drawer
reflection
army
resource
people
writing
people
volume
reception
scene
son
pie
population
combination
weakness
impression
gate
worker
computer
song
proposal
history
fact
love
contract
|
|
| Count of resources | 8,180,456 (bugwest kiwi dataset) |
| Count of subjects | 4,078,882 |
| Performance Test duration | 300 (5 min) |
| V_USERS | 5 |
| RAMP_UP | 5 sec |
| HOSTNAME | falcon-perf-okapi.ci.folio.org |
Aggregated Results
| Table chart |
|---|
| barColoringType | mono |
|---|
| tfc-width | 1000 |
|---|
| colorColumns | |
|---|
| innerlabels | None |
|---|
| column | Label |
|---|
| aggregation | Min‚Max‚Average |
|---|
| isNew | true |
|---|
| type | Bar |
|---|
| version | 3 |
|---|
| colors | #8eb021,#d04437,#3572b0 |
|---|
| isFirstTimeEnter | true |
|---|
| tfc-height | 400 |
|---|
| datepattern | dd M yy |
|---|
| pieKeys | Current solution‚Query filters enabled‚Terms queries |
|---|
| id | 1650449752242_-1580003586 |
|---|
| worklog | 365|5|8|y w d h m|y w d h m |
|---|
| formatVersion | 3 |
|---|
|
| Label | # Samples | Average | Min | Max | Std. Dev. | Error % | Throughput | Received KB/sec | Sent KB/sec | Avg. Bytes | Cache Usage, MB |
|---|
| Current solution | 667 | 2239 | 244 | 5703 | 1156.73 | 0.00% | 2.21114 | 15.41 | 1.14 | 7136.2 | 3.5 | Optimized query with terms filter | 1791 | 832 | 234 | 6577 | 511.44 | 0.00% | 5.95179 | 41.47 | 3.07 | 7134.5 | 6.5 | | Terms queries | 1707 | 873 | 245 | 3780 | 527.85 | 0.00% | 5.66831 | 39.5 | 2.93 | 7135.1 | 26.7 |
|
...