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.