Uploaded image for project: 'Archive mifos 2.x'
  1. Archive mifos 2.x
  2. MIFOS2X-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

            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: