Search performance speed enhancement

Description

Overview: Particularly in instances of FOLIO with many records loading orders after a search can take over 30 seconds.

App name/area of issue: Order/search orders and order lines

Brief statement of issue: Searches can take 10-15 seconds to return results

How many users at any given time: Uncertain that this has an impact as there would not have been more than 20-30 users in the Q1 bugfest environment

Volume of data; 15k order records, 15k+ order lines, 7k organizations, 15k+ inventory records

Expected response time: 5 seconds

Outline steps for test:

  • Open order app

  • select a filter or add a search term

  • Wait for result list to load

Environment

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Dennis BridgesMay 21, 2021 at 5:07 PM

I'm closing this UI story as won't do because we have decided to implement cross index sub-queries for orders that should resolve this performance issue. Any additional UI work required will be defined in future stories.

Aliaksei ChumakouMarch 26, 2021 at 8:19 AM

 I'm not sure what could be done from front-end side. Description looks like purely back-end response time decreasing. I suggest  to take a look into this ticket. 

Stephanie BuckJune 11, 2020 at 7:57 PM

Thanks !

Dennis BridgesJune 11, 2020 at 7:33 PM

I think I would keep this as a P3 at the moment as it doesn't block any or our workflows. However, it is a major inconvenience for users.

Stephanie BuckJune 11, 2020 at 2:01 PM

Hi - is this a P2 or P3 priority? Thanks!

Won't Do

Details

Assignee

Reporter

Tester Assignee

Priority

Development Team

Thunderjet

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created April 2, 2020 at 12:05 AM
Updated June 7, 2021 at 8:54 PM
Resolved May 21, 2021 at 5:07 PM
TestRail: Cases
TestRail: Runs

Flag notifications