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)