fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sachin Kulkarni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (FINERACT-144) Performance improvement for accrual job
Date Wed, 27 Apr 2016 06:08:12 GMT
Sachin Kulkarni created FINERACT-144:
----------------------------------------

             Summary: Performance improvement for accrual job 
                 Key: FINERACT-144
                 URL: https://issues.apache.org/jira/browse/FINERACT-144
             Project: Apache Fineract
          Issue Type: Improvement
          Components: Charges
            Reporter: Sachin Kulkarni
            Assignee: Markus Geiss


For each loan picked up by the accrual job it tries to fetch the Loan Charges. The query used
to fetch the loan charges has a sub query which does not have loan id in the where clause
this is making query performance issue.

Adding loanId in this loan charge query improves the performance of accrual batch job.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message