Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

keyword search slow / times out

Description

Tests involving keyword searches on /instance-storage/instances seem very slow .
Queries executed:

keyword all many sortby title

keyword all many

Using mod-inventory-storage-19.0.0-SNAPSHOT.391

Perf env

https://jenkins-aws.indexdata.com/job/Automation/job/folio-perf-platform/455/performance/uriReport/jmeter_perf.jtl%3APerf+-+GET+inventory_instances+%28keyword+all+%22%7BinstanceKeyword%7D%22%29+sortby+title.endperformanceparameter/

We need this test to perform correctly before we can close this ticket.

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

TestRail: Results

Activity

Show:

Julian LadischMarch 7, 2020 at 10:51 AM

The public.concat* issue was introduced by https://github.com/folio-org/raml-module-builder/commit/872c1f80da4c8d49e6836ca9221f637dc5e7420b and was released as RMB 29.3.0.
I will fix it as part of RMB-583.

Hongwei JiMarch 7, 2020 at 4:02 AM

, it is actually taking 400s not 40s. The slowness is due to mismatch between index and query. The index (see below) has public qualifier before concat_xxx functions. Why is that? RMB main.ftl sets db search path to public first, and those public functions are likely from modules that have not been updated to RMB 29.3.0.

The query generated is

Jakub SkoczenMarch 6, 2020 at 10:58 AM

Julian LadischMarch 6, 2020 at 10:20 AM

Performance of mod-inventory-storage master = 081f5bb from March 5 using the 2761297 instances from the performance data set:
query = keyword all many

query = keyword all many sortby title

Done

Details

Assignee

Reporter

Labels

Priority

Sprint

Development Team

Core: Platform

Fix versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created March 5, 2020 at 1:50 PM
Updated March 14, 2020 at 12:58 PM
Resolved March 13, 2020 at 5:59 PM
TestRail: Cases
TestRail: Runs