[
http://mifosforge.jira.com/browse/MIFOS-3084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=58363#action_58363
]
johnwoodlock commented on MIFOS-3084:
-------------------------------------
Info for Jeff:
Noticed slow performance on the following size dataset (local machine)
Customers: 220K
Customer Schedules: 18.5M
Savings Schedules: 993
I had done work on this batch job previously and knew that it had been updated
for office holidays (and moratoriums) so did a check.
I had mysql query caching enabled. Updates were taking about 56 seconds per
1000 customers. The difference to the previous version was that working days
and office holidays were being requested from the database for every account
processed.
After the fix updates were taking around 27 seconds per 1000 customers.
> GenerateMeetingsForCustomerAndSavings performance regression due to office
> holiday changes
> ------------------------------------------------------------------------------------------
>
> Key: MIFOS-3084
> URL: http://mifosforge.jira.com/browse/MIFOS-3084
> Project: mifos
> Issue Type: Bug
> Components: Batch jobs
> Affects Versions: Shamim D
> Reporter: johnwoodlock
> Assignee: Kay Chau
> Priority: Major
> Fix For: Shamim D
>
> Original Estimate: 4 hours
> Remaining Estimate: 4 hours
>
> The GenerateMeetingsForCustomerAndSavings batch job has regressed performance
> wise due to office holiday changes. Its approx. twice as slow as previous.
> Its not a show-stopper but don't particularly want to see this batch job
> perform worse with Shamimd release.
> Expect to fix in Marie E and to port the fix to 1.6.x too.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
