Uploaded image for project: 'SimplyE 2.0'
  1. SimplyE 2.0
  2. SIMPLY-1727

Older databases don't have an important unique index on licensepooldeliveries

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: High High
    • 2.3.2cm
    • Server - Core
    • None
    • S4 SIMPLY Feb 6 - Feb 19

      in 20190111-unique-delivery-mechanisms we remove a 'redundant' index:

      -- The ix_licensepooldeliveries_datasource_identifier_mechanism index
      -- is not necessary - an index is automatically created on the same
      -- fields to enforce a uniqueness constraint.
      drop index if exists ix_licensepooldeliveries_datasource_identifier_mechanism;

      But on older circulation managers, this index isn't redundant, because the uniqueness constraint was never created – I added it to the model but didn't add a migration script. Dropping this index is terrible for the performance of the lane query. We need the migration script that should have been added in the first place.

            leonardrichardson Leonard Richardson [X] (Inactive)
            leonardrichardson Leonard Richardson [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: