msupply-foundation / conforma-server

Conforma application manager (IRIMS) back-end
GNU Affero General Public License v3.0
4 stars 1 forks source link

Performance Improvement: getReviewResponses #1078

Closed jmbrunskill closed 4 months ago

jmbrunskill commented 12 months ago

Summary

The getReviewResponses seems to be called frequently within the application, and has sometimes shown very slow performance on production servers. e.g. taking 30seconds!

image

image

During completing a review this was called 6 times resulting in around 3minutes of waiting time for the user. image

Why is it slow?

It's not clear! Seems to be fast locally, and reasonably fast on some servers.

How concerned are we?

This is the biggest slow down for users who need to approve applications. It appears that moving to different server infrastructure might have helped, so maybe was a hardware issue?

Possible Solutions:

Needs more investigation.

Agreed Solution

TBD

CarlosNZ commented 4 months ago

Sorted (for now) with latest changes