[jira] [Commented] (FINERACT-1165) Savings Account Scalability Improvement

["bharath gowda (Jira)" <ji...@apache.org>]

    [ 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)