fineract-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nayan Ambali <nayan.amb...@gmail.com>
Subject Re: Speed of runaccruals endpoint
Date Tue, 15 Mar 2016 12:07:37 GMT
Sander,

One my customer is facing this issue, job is running for 4days, around 110k
loans :(

Can you please share the fix.


Thanks
Nayan Ambali


On Mon, Mar 14, 2016, 7:02 PM Sander van der Heyden <
sandervanderheyden@musoni.eu> wrote:

> Hi guys,
>
> We are experiencing some issues with the manual triggering of the
> 'runaccruals' endpoint. When the customers are running this, it can take up
> to 15 hours to complete, with an outstanding loan book of 30.000 loans.
>
> The main issue seems to be that because this goes through the
> processAndLogCommand, all DB queries will only be committed once the
> process has completed. In this case that means about 30.000 or so inserts
> in m_loan_transaction, with a multitude of that in acc_gl_journal_entry
> (and a similar number of updates to repayment_schedules). The difference in
> the regular jobs is that these will commit one loan after the other,
> speeding up the process significantly, and allowing it to complete in 2 or
> 3 hours (still not great, but a lot better).
>
>  Has anyone else run into this issue as well, and if so already made code
> improvements to avoid it?
>
> S
>
>
> --
> Sander van der Heyden
>
> CTO Musoni Services
>
>
>
>
> Mobile (NL): +31 (0)6 14239505
> Skype: s.vdheyden
> Website: musonisystem.com
> Follow us on Twitter!  <https://twitter.com/musonimfi>
> Postal address: Hillegomstraat 12-14, office 0.09, 1058 LS, Amsterdam,
> The Netherlands
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message