[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:
Relates
relates to MODINVSTOR-292 Search instances by item.barcode is slow Closed
Sprint: CP: sprint 78
Story Points: 0.5
Development Team: Core: Platform

 Description   

The performance regression is significant – a single request takes almost 86s.

See here https://jenkins-aws.indexdata.com/job/Automation/job/folio-perf-platform/346/performance/uriReport/jmeter_perf.jtl%3APerf+-+GET+instance-storage_instances%3Fquery%3D%28item.barcode%3D%3D%7BitemBarcode%7D%29.endperformanceparameter/

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 MODINVSTOR-292 Closed

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.

Generated at Thu Feb 08 23:21:08 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.