Description
When tested the load capacity on the platform for the savings module with 40k accounts along with around 100 Transactions for each account, it takes approx 45 Sec to bring up a savings account.
With some help, we have identified that the query attached was causing the delay.
further identified the solution that adding an index to a column "savings_account_transaction_id" of table "m_note" would fix the issue.
We will be sending a PR to the 1.4 branch with below index flyway script and raising this ticket for reference.
Attachments
Attachments
Issue Links
- Blocked
-
FINERACT-1305 Release Apache Fineract v1.5.0
- Resolved
- links to