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

Savings Account Scalability Improvement

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.5.0
    • None

    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

        1. delay_query.sql
          2 kB
          Bharath Gowda

        Issue Links

          Blocked

          New Feature - A new feature of the product, which has yet to be developed. FINERACT-1305 Release Apache Fineract v1.5.0

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #1374

          Web Link GitHub Pull Request #1376

          Activity

            People

              bgowda Bharath Gowda
              bgowda Bharath Gowda
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: