[ 
http://mifosforge.jira.com/browse/MIFOS-4945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Lukasz Chudy updated MIFOS-4945:
--------------------------------

    Status: Ready for Showcase  (was: Ready for Testing / Resolved)

Verified on 05.05.2011
Currency indexes have been properly removed from trxn tables.

> Removing currency indexes from trxn tables
> ------------------------------------------
>
>                 Key: MIFOS-4945
>                 URL: http://mifosforge.jira.com/browse/MIFOS-4945
>             Project: mifos
>          Issue Type: Improvement
>          Components: Database
>    Affects Versions: Unscheduled
>            Reporter: johnwoodlock
>            Assignee: johnwoodlock
>             Fix For: Release G
>
>
> Similar to mifos-4700
> The 'trxn' tables (account_trxn, financial_trxn, loan_trxn_detail, 
> customer_trxn_detail, fee_trxn_detail and savings_trxn_detail) have a lot of 
> indexes (19) 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.

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