Avik Ganguly created FINERACT-427:
-------------------------------------

             Summary: Paginate input queries for jobs.
                 Key: FINERACT-427
                 URL: https://issues.apache.org/jira/browse/FINERACT-427
             Project: Apache Fineract
          Issue Type: Improvement
            Reporter: Avik Ganguly
            Assignee: Markus Geiss
            Priority: Minor


Paginate read queries for following jobs :

Add Accrual Transactions
Add Periodic Accrual Transactions
Add Accrual Transactions For Loans With Income Posted As Transactions
Generate Loan Loss Provisioning
Post Interest for Savings
Update Loan Summary


Add arbitrary page size (32000) for now which can be later replaced by the 
product of two configurations (batch size * thread count for that executor 
service pool) when jobs are made concurrent. 
If paginating the query outside can split a loan across pages, paginate the 
primary entity, i.e. loans or savings. 

Ex :- If accrual read query will fetch 3 rows for same loan (3 repayment 
schedule entries for which accrual is pending) and page size is 2,  loan will 
get split across 2 pages. Avoid this by paginating the loan entity inside the 
query.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to