[
https://issues.apache.org/jira/browse/FINERACT-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17207480#comment-17207480
]
bharath gowda commented on FINERACT-1165:
-----------------------------------------
Thank you for the Input Michael, We will send it to the Develop Branch.
> 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)
