...
Honeysuckle tests revealed the following missing indexes:
mod-circulation-storage missing indexes
| Code Block |
|---|
WARNING: Doing LIKE search without index for jsonb->>'requestId', CQL >>> SQL: requestId == 920e1d64-c221-48a0-a44d-ff50f3ad6cd6 >>> lower(f_unaccent(jsonb->>'requestId')) LIKE lower(f_unaccent('920e1d64-c221-48a0-a44d-ff50f3ad6cd6'))
WARNING: Doing FT search without index for request.jsonb->>'requesterId', CQL >>> SQL: requesterId = ae4c1cf3-0738-4465-8112-e75089e5b5c6 >>> get_tsvector(f_unaccent(request.jsonb->>'requesterId')) @@ tsquery_phrase(f_unaccent('ae4c1cf3-0738-4465-8112-e75089e5b5c6'))
WARNING: Doing FT search without index for request.jsonb->>'pickupServicePointId', CQL >>> SQL: pickupServicePointId = 7068e104-aa14-4f30-a8bf-71f71cc15e07 >>> get_tsvector(f_unaccent(request.jsonb->>'pickupServicePointId')) @@ tsquery_phrase(f_unaccent('7068e104-aa14-4f30-a8bf-71f71cc15e07'))
WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'patronId', CQL >>> SQL: patronId == d7cabcb2-7431-43ea-a2cc-0dfe5bee17c6 >>> lower(f_unaccent(patron_action_session.jsonb->>'patronId')) LIKE lower(f_unaccent('d7cabcb2-7431-43ea-a2cc-0dfe5bee17c6'))
WARNING: Doing LIKE search without index for patron_action_session.jsonb->>'actionType', CQL >>> SQL: actionType == Check-out >>> lower(f_unaccent(patron_action_session.jsonb->>'actionType')) LIKE lower(f_unaccent('Check-out')) |
...
Response Times Okapi-4.3.3
| Average (seconds) | 50th %tile (seconds) | 75th %tile (seconds) | 95th %tile (seconds) | |||||
| Check-in | Check-out | Check-in | Check-out | Check-in | Check-out | Check-in | Check-out | |
| 1 user | 0.94 | 2.158 | 0.885 | 2.017 | 0.969 | 2.177 | 1.198 | 2.906 |
| 5 users | 1.126 | 2.574 | 1.025 | 2.339 | 1.211 | 2.79 | 1.77 | 4.007 |
| 8 users | 1.313 | 2.948 | 1.177 | 2.61 | 1.487 | 3.274 | 2.195 | 5.045 |
| 20 users | 3.252 | 7.492 | 2.681 | 6.355 | 3.605 | 8.313 | 7.061 | 15.747 |
Response Times Okapi-4.6.1
| Average (seconds) | 50th %tile (seconds) | 75th %tile (seconds) | 95th %tile (seconds) | |||||||||
| Check-in | Check-in performance with okapi-4.3.3 | Check-out | Check-out performance with okapi-4.3.3 | Check-in | Check-out | Check-in | Check-in performance with okapi-4.3.3 | Check-out | Check-out performance with okapi-4.3.3 | Check-in | Check-out | |
| 1 user | 1.041 | -9.7% | 2.332 | -17%7% | 0.957 | 2.139 | 1.06 | 2.369 | 1.378 | 3.394 | ||
| 5 users | 1.057 | -0+6.3%5% | 2.374 | -9%+8.4% | 0.978 | 2.176 | 1.133 | 2.532 | 1.524 | 3.624 | ||
| 8 users | 1.277 | -7%+2.8% | 2.814 | -25%+4.7% | 1.144 | 2.512 | 1.44 | 3.074 | 2.112 | 4.718 | ||
| 20 users | 2.374 | +036.7%9% | 5.927 | -51+26.9%4% | 2.137 | 5.246 | 2.716 | 6.552 | 4.188 | 9.426 | ||
...