Slow page load on Physical Inventory page

Description

Malawi users had the following issue:

Users are experiencing slow page load whenever they click on Physical Inventory in Stock Management Module. The page keeps on loading for a really long time before it is actually displayed. Sometimes the page fails to load and it gives a Gateway Time OUT error, so the user has to keep on refreshing the page. This has lead to users failing to do Physical Inventory because they cannot access the Physical Inventory page for all programs.

It has been fixed by adding the following indexes to the database:

In this ticket, those indexes should be added by flyway migration to avoid manual creation for other instances.

Environment

None

Assignee

Klaudia Pałkowska

Reporter

Łukasz Lewczyński

Labels

Story Points

1

Time tracking

4h

Epic Link

Components

Sprint

None

Fix versions

Priority

Critical
Configure