mifos
  1. mifos
  2. MIFOS-4945

Removing currency indexes from trxn tables

    Details

    • Team:
      Core
    • Scheduled For:
      Release

      Description

      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.

        Activity

        Hide
        Mifos Hudson Jira Plugin User added a comment -

        Integrated in 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
        Show
        Mifos Hudson Jira Plugin User added a comment - Integrated in 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
        Hide
        johnwoodlock added a comment -

        Changes included in release G liquibase upgrade. Tested against a number of production MFI databases including a GK backup from about a year ago

        Notes that should go with Release G are in http://mifosforge.jira.com/wiki/display/MIFOS/Release+G+Potentially+Large+DB+Changes+and+PreUpgrade+Option

        Show
        johnwoodlock added a comment - Changes included in release G liquibase upgrade. Tested against a number of production MFI databases including a GK backup from about a year ago Notes that should go with Release G are in http://mifosforge.jira.com/wiki/display/MIFOS/Release+G+Potentially+Large+DB+Changes+and+PreUpgrade+Option
        Hide
        Lukasz Chudy added a comment -

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

        Show
        Lukasz Chudy added a comment - Verified on 05.05.2011 Currency indexes have been properly removed from trxn tables.
        Hide
        Kay Chau added a comment -

        Moving to Iteration 8 to update

        Show
        Kay Chau added a comment - Moving to Iteration 8 to update

          People

          • Assignee:
            johnwoodlock
            Reporter:
            johnwoodlock
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: