Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1165

Savings Account Scalability Improvement

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: None
    • Labels:

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              bgowda bharath gowda
              Reporter:
              bgowda bharath gowda

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment