[ 
http://mifosforge.jira.com/browse/MIFOS-4700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=67019#comment-67019
 ] 

Mifos Hudson Jira Plugin User commented on MIFOS-4700:
------------------------------------------------------

Integrated in !http://ci.mifos.org/hudson/images/16x16/blue.png! 
[head-master-secondary 
#326|http://ci.mifos.org/hudson/job/head-master-secondary/326/]
     MIFOS-4700, MIFOS-4945, MIFOSSUPPORT-44, MIFOS-4286 upgrade additions

John Woodlock : 
Files : 
* db/src/main/resources/changesets/changelog-PreRelease_G.xml


> 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
>
>
> 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

        

------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network 
management toolset available today.  Delivers lowest initial 
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to