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@lists.koha-community.org Reporter: dcook@prosentient.com.au QA Contact: testopia@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.