Performance issue on approve screen

Description

We noticed in Malawi that users can not go to the approve screen. We checked and the endpoint tries to return 10 elements from about 5,000 requisitions. A request takes more than 15 minutes after that time users get a gateway timeout error. Probably the issue is related to a call to the database.

Acceptance criteria

  • users should be able to go to the approve screen

  • this should be verified in the core and in malawi

  • this should be verified with requisition with and without rejected status

    • in this way, a requisition will have several authorized statues and we need this to verify that the endpoint does not return duplications

 

Environment

None

Status

Assignee

Łukasz Lewczyński

Reporter

Łukasz Lewczyński

Time tracking

2h 30m

Components

Sprint

None

Fix versions

Priority

Blocker
Configure