Skip to:

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

Inefficient query on Inventory Transfer Request screen is causing slow results

Description

Reported by MU on 3-1-2025 call, verified by Jeff

MU central supply is complaining that the Inventory Transfer Request screen is taking a long time to search for products by description. We verified on the call that a product lookup is taking 10-15 seconds search time.

We also confirmed that if they turn on the “look up all products” switch it is taking 1-2 seconds like normal, so the problem is on the query that unifies the products between the Source Unit and the Destination Unit. This issue is not replicated in UGA production or Support 4.2.X dev, but is replicated on every unit at MU.

Jeff says we need to improve the efficiency of the query.

Jeff suggests adding indexes to these columns. (Although the issue was reported for Hospital, if this is applicable to the Labs Inventory Transfer Request screen, it’ll need to be done there too.)

This is the query that Jeff sent to Justin to test, which Justin confirmed is also taking 10+ seconds raw from the MU production database.

Attachments

2

Activity

Cathy Allison 
March 31, 2025 at 10:03 PM

Testing in Support QA 4.2.11 Build #33

Because we weren't able to reproduce this issue locally, we will need to have it fully verified by MU.

However, I was able to search for products and submit them without errors locally, so the fix is confirmed to be functional. Actual performance will need to be measured once it is live in their UAT environment.

Abraham Westfall 
March 28, 2025 at 9:29 PM

Switched to CreateCriteria calls and only return a List of ids.

Fixed

Details

Assignee

Reporter

Fix versions

Components

Features

Hospital or Labs?

Priority

Labels

Sprint

Goals

None
Created March 21, 2025 at 3:15 PM
Updated March 31, 2025 at 10:03 PM
Resolved March 31, 2025 at 10:03 PM