[
http://mifosforge.jira.com/browse/MIFOS-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=64781#action_64781
]
johnwoodlock commented on MIFOS-4700:
-------------------------------------
Note: would also drop the foreign key to currency table (if there) e.g.
ALTER TABLE `mifos`.`loan_schedule` DROP FOREIGN KEY `loan_schedule_ibfk_15`
, DROP INDEX `extra_interest_paid_currency_id` ;
> 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