bharath gowda created FINERACT-1165:
---------------------------------------
Summary: Savings Account Scalability Improvement
Key: FINERACT-1165
URL: https://issues.apache.org/jira/browse/FINERACT-1165
Project: Apache Fineract
Issue Type: Improvement
Reporter: bharath gowda
Assignee: bharath gowda
Fix For: 1.4.0
Attachments: delay_query.sql
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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
