[FOLIO-2503] GET instance-storage_instances?query=(item.barcode=={itemBarcode}) has regressed Created: 06/Dec/19 Updated: 03/Jun/20 Resolved: 09/Dec/19 |
|
| Status: | Closed |
| Project: | FOLIO |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None |
| Type: | Task | Priority: | P1 |
| Reporter: | Jakub Skoczen | Assignee: | Hongwei Ji |
| Resolution: | Done | Votes: | 0 |
| Labels: | platform-backlog | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Issue links: |
|
||||||||
| Sprint: | CP: sprint 78 | ||||||||
| Story Points: | 0.5 | ||||||||
| Development Team: | Core: Platform | ||||||||
| Description |
|
The performance regression is significant – a single request takes almost 86s. The regression has begun with perf test build #323 https://jenkins-aws.indexdata.com/job/Automation/job/folio-perf-platform/323/performance/ on November 15th. |
| Comments |
| Comment by Jakub Skoczen [ 06/Dec/19 ] |
|
Hongwei Ji Adam Dickmeiss Eric Valuk Julian Ladisch Guys, do you have any idea when and why this happened? We have addressed the problem for Q3.1 through
|
| Comment by Julian Ladisch [ 09/Dec/19 ] |
|
mod-inventory-storage master uses an expression that matches the barcode index. Need to install the latest perf dataset to see why it is slow in the performance environment. |
| Comment by Hongwei Ji [ 09/Dec/19 ] |
|
I did a quick test after re-vacuum analyze those three large tables, the query looks pretty fast. |
| Comment by Hongwei Ji [ 09/Dec/19 ] |
|
This is a pure perf env issue. Should be resolved now. See recent build #352 and #353 results. |