[
http://mifosforge.jira.com/browse/MIFOS-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau updated MIFOS-4700:
----------------------------
Fix Version/s: Mifos Backlog
Assignee: mifosdeveloperqueue
> 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: mifosdeveloperqueue
> Fix For: Mifos Backlog
>
>
> 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).
> 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 can be another Jira
> issue.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
Mifos-issues@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-issues
