Create, close, cancel, Purchase Orders (UXPROD-1141)

[UXPROD-2364] Order search performance Enhancements Created: 25/Mar/20  Updated: 28/Dec/21  Resolved: 11/Aug/21

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: R2 2021
Parent: Create, close, cancel, Purchase Orders

Type: New Feature Priority: P4
Reporter: Dennis Bridges Assignee: Dennis Bridges
Resolution: Done Votes: 0
Labels: acquisitions, orders, r2-2021-split, round_iv
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Issue links:
Cloners
is cloned by UXPROD-3088 Order searching and sorting updates Open
Defines
is defined by PERF-58 CLONE - Use cross-index subqueries in... Closed
is defined by MODORDERS-488 SPIKE: investigate transition of Orde... Closed
is defined by MODORDSTOR-210 Delete order and order lines views. ... Closed
is defined by MODORDSTOR-220 Performance issue with keyword search... Closed
is defined by MODORDSTOR-221 Performance issue adding date filter ... Closed
is defined by UIF-229 change mouse cursor for non-sortable ... Closed
is defined by UIOR-417 Retain filters when switching from PO... Closed
is defined by UIOR-541 Search performance speed enhancement Closed
is defined by UIOR-678 Filter order lines by Expense class Closed
is defined by UIOR-710 Filter order by subscription = yes/no Closed
is defined by UIOR-727 Support cross index queries for GET /... Closed
is defined by UIPFPOL-20 Support cross index queries for GET /... Closed
is defined by UIOR-648 Sort orders and order lines by Update... Closed
is defined by MODORDERS-503 Add GET orders cross index search sup... Closed
is defined by MODORDERS-504 Add GET PO lines cross index search s... Closed
Relates
relates to MODORDSTOR-228 Switch GET /orders-storage/po-lines s... Closed
relates to MODORDSTOR-229 Switch GET /orders-storage/orders sea... Closed
Epic Link: Create, close, cancel, Purchase Orders
Front End Estimate: XL < 15 days
Back End Estimate: XL < 15 days
Development Team: Thunderjet
PO Rank: 72.3
PO Ranking Note: I have lowered the priority of this issue because the performance related stories were moved to UXPROD-2169. These were moved because they represent technical debt rather than enhancements
Cap Plan Fix Version (DO NOT CHANGE): R2 2021
Rank: Chalmers (Impl Aut 2019): R3
Rank: Chicago (MVP Sum 2020): R1
Rank: Cornell (Full Sum 2021): R1
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R1
Rank: GBV (MVP Sum 2020): R1
Rank: MI State-Lib of MI (Sum 2021): R2
Rank: TAMU (MVP Jan 2021): R1
Rank: U of AL (MVP Oct 2020): R3

 Description   

Overview: This feature includes updates and enhancements for improving order searching.

UPDATE: Opting in to the "Load more" function of the search results component has seemed to improve performance here substantially by limiting the number fo results that will be displayed for any given search.

Search continues to be very slow when searching or applying filters in bugfest environments with substantial amounts of data

Note: Sorting enhancements were split into UXPROD-3088 Open as there is not enough capacity remaining for Juniper release

Scope:

  • Improve search performance with large data sets
  • Improve search performance of filters
  • Include additional search filters and parameters if possible

Requirements, Investigation and decisions relating to this feature are available at https://folio-org.atlassian.net/wiki/display/DD/Orders+search+performance+improvements



 Comments   
Comment by Julie Brannon [ 07/May/20 ]

I'm not sure how we're supposed to rank this since there isn't a description. If leaving these feature out negatively impacts performance, then I assume it should be ranked go-live, but it might be helpful for more guidance on ranking this. Thanks!

Comment by Dennis Bridges [ 07/May/20 ]

Thanks Julie Brannon, I have added some additional detail in the description that attempts to summarize the attached user stories. This is specifically a performance related issue dealing with the speed at which information is returned to the orders interface and displayed for users. This is a Non-functional requirement in that it will not add functionality you might need per se. However, it is reasonable to rank it as a go live if you would not use FOLIO with the potential for the system to return search results slowly.

Comment by Julie Brannon [ 08/May/20 ]

This helps - thanks!

Comment by Dennis Bridges [ 15/Jun/20 ]

Opting in to the "Load more" function of the search results component has improve performance here substantially. Limiting the number of results that will be displayed for any given search. For this reason the PO rank of this feature has been lowered. All other technical debt stories have been moved to UXPROD-2492 Draft so this body of work can be considered independently of other technical improvements.

Comment by Kay Granskog [ 30/Mar/21 ]

Michigan State-LM is particularly interested in filtering by expense class.

Comment by Dennis Bridges [ 11/Aug/21 ]

All issues tested and closed

Generated at Fri Feb 09 00:23:20 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.