[
https://issues.apache.org/jira/browse/FINERACT-1165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17205050#comment-17205050
]
Michael Vorburger commented on FINERACT-1165:
---------------------------------------------
> We will be sending a PR to the 1.4 branch with below index flyway script and
> raising this ticket for reference.
Cool! But do send it to the develop branch, not 1.4.0 branch.. we're about to
delete that, see FINERACT-1154. There are no plans, that I'm aware of, to do
active 1.4.x maintenance, and e.g. release a 1.4.1 some time. Unless you would
like to step up as Release Manager for a 1.4.1; which you are, of course, free
to do!
> 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.4.0, 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)
