fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Santosh Math (JIRA)" <>
Subject [jira] [Updated] (FINERACT-427) Paginate input queries for jobs.
Date Wed, 19 Apr 2017 11:50:41 GMT


Santosh Math updated FINERACT-427:
    Labels: p2 performance  (was: performance)

> Paginate input queries for jobs.
> --------------------------------
>                 Key: FINERACT-427
>                 URL:
>             Project: Apache Fineract
>          Issue Type: Improvement
>            Reporter: Avik Ganguly
>            Assignee: Markus Geiss
>            Priority: Minor
>              Labels: p2, performance
> 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

View raw message