[ https://issues.apache.org/jira/browse/FINERACT-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Vorburger resolved FINERACT-1165. ----------------------------------------- Resolution: Fixed > 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 > Priority: Major > Labels: beginner > Fix For: 1.5.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)