[FINERACT-144] Performance improvement for accrual job

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: Charges
• Assignee: Adi Raju
• Reporter: Sachin Kulkarni
• Created: 27/Apr/16 06:07
• Updated: 11/May/16 11:33
• Resolved: 27/Apr/16 08:52

Description

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.