[
http://mifosforge.jira.com/browse/MIFOS-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOS-4700:
----------------------------
Status: Ready to Ship / Verified (was: Ready for Showcase)
> Removing currency indexes from schedule tables
> ----------------------------------------------
>
> Key: MIFOS-4700
> URL: http://mifosforge.jira.com/browse/MIFOS-4700
> Project: mifos
> Issue Type: Improvement
> Components: Database
> Affects Versions: Unscheduled
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Fix For: Release G - Iteration 8, Release G
>
>
> The schedule tables (loan_schedule (13), loan_fee_schedule (2),
> customer_schedule (1), customer_fee_schedule (2) and savings_schedule (3))
> have a lot of indexes on currency id columns.
> They don't need any of them. Where more than one currency is catered for in
> mifos (not often) the 'group by' or currency access point would be on the
> account currency_id column.
> Hard to gauge the likely performance benefits... it will vary by size of MFI
> but better not to have them if not needed I think. (could run performance lab
> test on schedule creation but not sure its worth going to that effort).
> Certainly, there is a reduce disk space requirement e.g. about 40% for
> loan_schedule (though less for the others)
> For GK this would be an example of a script that can be run prior to an
> upgrade to save time (c.f. recent Liquibase work)
> Same is true on the big 'transaction' tables but that is on another Jira
> issue - mifos-4945
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
