Uploaded image for project: '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.

        Attachments

          Activity

          Hide
          mifos-hudson 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 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 johnwoodlock (Inactive) 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 johnwoodlock (Inactive) 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
          lukaszch Lukasz Chudy (Inactive) added a comment -

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

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

          Moving to Iteration 8 to update

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: