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
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.
-
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
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
