From commits-return-12709-archive-asf-public=cust-asf.ponee.io@fineract.apache.org Wed Oct 14 17:36:27 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org [3.227.148.255]) by mx-eu-01.ponee.io (Postfix) with ESMTPS id 4204618063F for ; Wed, 14 Oct 2020 19:36:27 +0200 (CEST) Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153]) by mxout1-ec2-va.apache.org (ASF Mail Server at mxout1-ec2-va.apache.org) with SMTP id 672284330B for ; Wed, 14 Oct 2020 17:36:26 +0000 (UTC) Received: (qmail 75632 invoked by uid 500); 14 Oct 2020 17:36:26 -0000 Mailing-List: contact commits-help@fineract.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@fineract.apache.org Delivered-To: mailing list commits@fineract.apache.org Received: (qmail 75623 invoked by uid 99); 14 Oct 2020 17:36:26 -0000 Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Oct 2020 17:36:26 +0000 From: =?utf-8?q?GitBox?= To: commits@fineract.apache.org Subject: =?utf-8?q?=5BGitHub=5D_=5Bfineract=5D_bharathcgowda_opened_a_new_pull_reques?= =?utf-8?q?t_=231376=3A_FINERACT-1165?= Message-ID: Date: Wed, 14 Oct 2020 17:36:26 -0000 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit bharathcgowda opened a new pull request #1376: URL: https://github.com/apache/fineract/pull/1376 FINERACT-1165 **resending the PR** 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. further identified the solution that adding an index to a column "savings_account_transaction_id" of table "m_note" would fix the issue. This Pull request contains a flyway script to add indexing to the m_note table's savings_account_transaction_id column. Note: I have used the Version number as V363 as the latest on develop branch was V362. Not sure how we are maintaining and picking the numbers in series, please let me know if V363 is already taken and to which number I can change. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org