[ https://issues.apache.org/jira/browse/FINERACT-144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adi Raju closed FINERACT-144. ----------------------------- Assignee: Adi Raju (was: subramanyasn) Fixed > 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: Adi Raju > > 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)