verify performance of RMB26 versions of mod-inv-s, mod-circ-s and mod-users
Description
Environment
Potential Workaround
Attachments
blocks
is blocked by
relates to
Checklist
hideTestRail: Results
Activity
Hongwei Ji July 18, 2019 at 8:28 PM
Latest perf result looks good. https://github.com/folio-org/mod-inventory-storage/blob/master/ramls/instance.json. The only really slow ones are searching instances by joining other tables.
Julian Ladisch July 16, 2019 at 11:40 AM
The warning is from CQL2PG, the "CQL >>> SQL" message is from RMB CQLWrapper.
Therefore moving the warning below the CQLWrapper line is not possible.
Hongwei Ji July 15, 2019 at 6:28 PM
The fix made by (match FT index with FT search in RMB 26.2.0) made a big difference. The new array syntax search time is down from a few minutes to under 100ms. As of now, there are three slow tests left.
1) search item by item barcode. This is due to a mismatch between index and query. Should be an easy fix. I will resolve this today.
2 and 3): checkin and checkout. We have to wait a) the latest mod-circulation-storage build (with RMB 26.2.0). Hopefully the PR this morning to bump up ui-users dependency to loan-storage interface will resolve this); b) audit_table PK violation issue get resolved (WIP by ).
BTW , RMB does log the CQL query and SQL right after the WARNINGS message. For example:
Jakub Skoczen July 15, 2019 at 9:07 AM
It would be great if those WARNINGS above logged also the CQL query (or at least index relation term for this particular node of the query)
Jakub Skoczen July 15, 2019 at 9:05 AM
How is the performance after those updates? Did it help if any of the cases? What slow queries remain?
Details
Details
Assignee
Hongwei JiReporter
Jakub SkoczenLabels
Priority
P2
Please check if there are any performance regressions or API errors on folio-perf-platform when running with mod-circulation-storage, mod-inventory-storage and mod-users based on RMB 26. Please report here any particular regressions as compared to previous succesfull runs.
Also, please review RMB logfiles for those modules to check for any WARN messages about missing indexes, e.g missing FT, GIN and BTREE indexes for specific queries. Please report the occurrences of those warnings and corresponding CQL and SQL queries here.