[
https://issues.apache.org/jira/browse/FINERACT-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
bharath gowda updated FINERACT-1165:
------------------------------------
Attachment: delay_query.sql
> 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
> 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)
