[Koha-bugs] [Bug 25661] New: auth_header missing authtypecode index

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25661

            Bug ID: 25661
           Summary: auth_header missing authtypecode index
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org

While code like tools/export.pl and Koha/MetadataRecord/Authority.pm all seem
to rely primarily on the authid primary key, it seems to me that there are
scenarios where you want to report on authority records using only the
authtypecode field.

At the moment, the database has to do a row scan through every auth_header row
in order to determine which records to return.

If we used an authtypecode index, the database would be able to process the
search query much quicker and do much less work on the backend.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.