[quoting-service] Quoting service stalls on large concurrent requests/loads

[kleyow]

Summary:
When the quoting service in the performance test harness is hit with large concurrent requests with 20+ k6s VU's, requests begin to stall and time out.

https://github.com/mojaloop/ml-core-test-harness

• Investigate primary cause of the issue
• Investigate why there are table locks
• Reduce model transaction length by moving transaction start right before it is needed
• Attempt to solve any issues identified if they are baisc. If this requires a more complex solution then write up those stories.
• Create quote parties pair in a singular insert
• Group select in promise.all
• Clean up the code

Severity:
(Low, Medium, High)

Priority:
(Critical, Medium, Low)

Expected Behavior

Steps to Reproduce
1.
2.
3.

Specifications

• Component (if known):
• Version:
• Platform:
• Subsystem:
• Type of testing:
• Bug found/raised by:

Notes:

• Severity when opened:
• Priority when opened: