Requisition search endpoint is slow

Description

In Malawi, we try to retrieve requisitions with a set of statuses and only those that have been initiated after 2019-01-01. We noticed that we have to wait for results even if there is only 30,394 requisitions that match our requirements. We checked the endpoint performance and the following table shows our measures:

Page size

Response time

10

63,273ms

100

756,684ms

50

488,138ms

Acceptance criteria

  • Response times should be below 1 minute

  • Each change should be tested on Malawi instance

 

Environment

None

Status

Assignee

Łukasz Lewczyński

Reporter

Łukasz Lewczyński

Time tracking

3h

Components

Sprint

None

Fix versions

Priority

Critical
Configure